Formula returning wrong answer
 

Maybe its a very small positive number returned by a formula in DE20
(which looks like a zero due to cell formatting as number to zero dp)

Try using a ROUND(..,0) ie:
=ROUND(<formula in DE20,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff Gross" wrote:
I have the following formula in a spreadsheet:

=IF(($DE200),$DE20*200000/$DE25,"")

I want the formula (DE20*200000/DE25) to be calculated only if DE20 is
greater than zero. The value of DE=0 so I expected to see a blank (because
of the "" in the if statement). Instead it is returning a #div/0! error.
Actually this error is showing up in 2 cells with the same type of formula
but it is returning accurately in about 50 others with the same formula. I
checked the cell format and they are all formatted as numbers.

Anyone have any ideas?

Jeff

Formula returning wrong answer
 

I tried your suggestion and it worked so i went back to the original cells
and found the issue. It was returning a very small number greater than 0.

Thanks a lot.

Jeff

"Max" wrote:

Maybe its a very small positive number returned by a formula in DE20
(which looks like a zero due to cell formatting as number to zero dp)

Try using a ROUND(..,0) ie:
=ROUND(<formula in DE20,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff Gross" wrote:
I have the following formula in a spreadsheet:

=IF(($DE200),$DE20*200000/$DE25,"")

I want the formula (DE20*200000/DE25) to be calculated only if DE20 is
greater than zero. The value of DE=0 so I expected to see a blank (because
of the "" in the if statement). Instead it is returning a #div/0! error.
Actually this error is showing up in 2 cells with the same type of formula
but it is returning accurately in about 50 others with the same formula. I
checked the cell format and they are all formatted as numbers.

Anyone have any ideas?

Jeff