| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returning wrong result. | Excel Worksheet Functions | |||
| Fill down produces correct formula but wrong answer | Excel Worksheet Functions | |||
| Formula correct, answer wrong | Excel Discussion (Misc queries) | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
| Wrong answer after using the payment formula in excel | New Users to Excel | |||
Linear Mode
