#DIV/0! to disappear

**krokodilos75** · 02-09-2009, 07:57 AM

I am building a model and some input data is still missing. Given that some calculations are performed with these data, excel returns #DIV/0! (where input cell is blank or 0).

Is there a way to disappear these #DIV/0! given that I would like to have my formulae in place as new input data may evolve in the future?

**DonkeyOte** · 02-09-2009, 07:58 AM

It is best to setup your formulae such that they do not try to divide is divisor is zero, eg:

=IF(N(B1),A1/B1,"")

So if B1 is 0 or text etc a Null value "" is returned, only if B1 were numeric and anything other than zero would the division be processed.

**krokodilos75** · 02-09-2009, 08:03 AM

Excellent!. Thank you very much.

**DonkeyOte** · 02-09-2009, 08:04 AM

I just noticed you're running Excel 2007 in which case you can in fact use:

=IFERROR(A1/B1,"")

Change the Null ("") to be whatever you want returned if the preceding calculation results in an error.

NOTE: this function is not backwards compatible so if you ever need to run the spreadsheet on an earlier version you should use the approach mentioned in the first post.