Excel -Kill off #DIV/0!

Posted on June 9, 2015 by JS

Are you as sick of that #DIV/0! as I am?

Wrap it in this

=IFERROR(MyFormulaHere,0)

or if you want text instead then use

=IFERROR(MyFormulaHere,"N/A")
This entry was posted in Interactive Conversation and tagged . Bookmark the permalink.