divide by 0

  • Thread starter Thread starter Rick Oakley
  • Start date Start date
R

Rick Oakley

I have a formula that divides some values. At times it
divides by zero. I don't care if it does I just don't want
to see it in the cell. How do I hide that message and show
the other valus?
 
Let's say your formula is =A2/B2
Replace this by =IF(B2<>0,A2/B2,"")
 
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

Divide by the minimum non-zero number in a range of cells 21
Average 2
Divide by zero error 3
Divide two cells and if the number is negative display is as zero 2
divide by zero 4
I need my SMALL formula to ignore zero's 7
Formula's 1
aauugghhh...#div/o problems & various average formula problems 5

Back
Top