Error #div/0!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a calculation in Excel which has to be updated every month
and I have the calculations set up correctly. But as I have to wait every
month for the new data when there is no data in the cells this error pops up
in the cell instead, is there anyway the #div/0! can be replaced with a blank
cell while still automatically performing the calculation, when I enter the
expected data.
 
=if(iserror(YOUR FORMULA),"",YOUR FORMULA)

This will first check if the result of the formula is an error or not, if so
it will be a blank cell, if its not an error it will do the forumla
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#div/0 error 2
DIV/0 error 5
Zeros and #DIV/0! 5
Div 0 help 1
# DIV/0! error in Excel 8
I want to see blank cell rather to see #DIV/0! 4
Div/0 error on running mean % 2
Conditional Formatting for #DIV/0! 6

Back
Top