ExcelBanter - Formula returning wrong answer

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula returning wrong answer (https://www.excelbanter.com/excel-worksheet-functions/158336-re-formula-returning-wrong-answer.html)

Formula returning wrong answer

Maybe:-

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

Mike

"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

Slightly shorter

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

"Mike H" wrote:

Maybe:-

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

Mike

"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