Formulas Divided by 0 =#Div/0!

Giganews Newsgroups
Subject: Formulas Divided by 0 =#Div/0!
Posted by:  Chad Cameron (chadNOT483@hotmail.com remove NOT)
Date: Fri, 13 Mar 2009

I usually come across this problem, and I fix it with a simple if statement.

But today, I have received a huge spreadsheet and this problem is all over
the place, at least 100 entries.  Cut and paste the modifed formula with an
if statement will not work.

Is there an easier way to show a 0 or blank in this cells instead of #Div/0!

Thanks
Chad

Replies