<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=371557583225568&amp;ev=PageView&amp;noscript=1">

BizNetSoftware Blog

Excel Tip & Trick: DIV/0 Error

Posted by Art Simmons |
January 07, 2016

Excel Tip & Trick of the Week: DIV/0 Error is used communally used for a percentage variance calculation to fill a zero or dash if the results is divided by zero. The IFERROR function will return a specified value if the operation returns an error like #DIV/0

Excel Tip and Trick IFERROR1.7

 

 

 

 

 

 

 

 

YoY$: =IFERROR(SUM(M24-N24),"-")

YoY %: = =IFERROR(SUM(M24-N24)/N24,"NA")

If you found this tip helpful and would like to see more head on over to the www.biznetsoftware.com!

About BizNet Software

BizNet Software, Inc. is a market leader for Microsoft Excel in-memory, cloud-enabled reporting and business intelligence. Founded in 1996 to take the mystery out of databases, BizNet focuses on Microsoft Excel reporting solutions guided by financial and business professionals with a real-world understanding of corporate financial, operational and technical requirements. The BizNet Excel Suite is the most innovative and intuitive reporting solution on the market. It creates a user-friendly, drag and drop environment with real time access to the most accurate and current data. Built upon fundamental business disciplines and controls, BizNet solutions make it easy for Microsoft Excel users to connect, analyze, and share real time information. BizNet Software is endorsed by more than 200 partners, 15 software publishers, and currently has 20,000+ users in more than 2,100 companies in 30 different countries.

Microsoft® and Excel® are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. For more information, visit http://www.biznetsoftware.com or call 888-803-5227.

 

Topics: Biz|Blog~

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all