Some Excel users do not mind the #DIV/0!, divide by zero error. I am not a fan, and whilst I like to be aware of any errors that Excel flags to me, on a presentation dashboard or a report, I think it does benefit from being tidied up somewhat and with a little bit of Excel formula magic. Watch the video to find out how.
Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the http://www.howtoexcelatexcel.com blog for lots of #exceltips
Join thousands of other Excel users who have already joined the Excel At Excel Monthly Newsletter. 3 FREE Excel Tips every month. Plus FREE 30 Tips EBook.
http://www.howtoexcelatexcel.com/newsletter-sign-up/
Be Social & Let’s Connect
++Website http://www.howtoexcelatexcel.com
++Twitter https://twitter.com/howtoexcelatex
Keep Excelling!.