Excel -Kill off #DIV/0!

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")
Advertisements
This entry was posted in Interactive Conversation and tagged . Bookmark the permalink.