I want to correct a #div/0! error but the IF function doesnt work

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

Guest

When i follow the conditional formatting instructions it doesnt remove the
#div/0! message that appears in the cells.

Possibly this is because the worksheet has already been created so I am not
entering this formula for each cell ... is there any quick way to do this to
the whole worksheet?
 
You must log in or register to reply here.

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
Macro to get rid of #DIV/0! 2
Dont want #DIV/0!. 3
dividing by 0 error 6
how do I clear #DIV/0!but leave the formula in cell 2
How to not get '0' or '#DIV/0!' in a cell with a percentage formul 5
how to sum cells and ignore the #div/0! 's ? 2
Average of time spent monthly getting DIV/0 error 2

Back
Top