What is wrong with this Formula???

  • Thread starter Thread starter M. Waugh
  • Start date Start date
M

M. Waugh

=IF(C8/D8=0,0,IF(C8/D8>0,(C8/D8)))

The results in the cell leaves #DIV/0!

I want the result of C8/D8 (if greater than 0) to show in
the cell.
Is there an easier way to leave a cell blank if the
formula equals zero. I would rather the cell be blank but
keep the formula.

Thanking you in advance for your assistance!

M. Waugh
 
You are having this problem, because you are always
dividing by D8, even if it contains zero. If you could
really divide by zero, the result would be infinity. What
you want to do is first test D8 for zero, and if it is
zero, give some results. Maybe zero is what you want to
show, even though it is not mathematically correct. The
formula would be =IF(D8=0,0,IF(C8/D8=0,0,IF(C8/D8>0,
(C8/D8)))).

Good luck,
Jim
(e-mail address removed)
 
Back
Top