What is wrong with this Formula???

[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

 

[Frank Kabel]

Hi
try
=IF(D8=0,0,MAX(C8/D8,0))

 

[Newbie]

Do you have 0 in D8?
What if the result is < 0?

 

[Don Guillett]

try
=IF(AND(NOT(ISERR(C8/D8)),C8/D8>0),C8/D8,"")

 

[Jim]

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)