Formula Error Message

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

Guest

Is there a way to not have the formula error message DIV/0! display in a cell
and still keep the formula?
 
If the formula is, e.g., =a1/b1 change it to =IF(B1=0,"",A1/B1)
 
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

Formula text in woorksheet cell 2
Average 1
divide by zero 1
Excel VBA 1
IRR Function Error Messages 4
Hiding the error caused by the formula in a cell / column 6
AverageIF 6
#DIV/0! in variance/percentage formula 3

Back
Top