Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fundamental problem with IF statement-None worked
You did not read what I wrote entirely. I did try with AND w/o the '=' char.
And I did use the default format which is "General". As I wrote, the problem is more fundamental. Anyway, thanks and if you have another idea you are welcome... David "David F" wrote in message news:... I have the following statement in cell E38: IF(C380,=ROUND(H38/C38,1),0) The E38 shows the formulas instead of the calculated values (value_if_true and value_if_false), regardless of whether C38 contains 0, 1 or left blank. Under any of those C38 values, E38 as stubborn whether I have the '=' before the ROUND or not and whether I specify the value_if_false (0) or not. H38 also contains a legitimate value. In the life of me, I could not figure out why this IF statement does not work. Any idea? Thanks, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fundamental problem with IF statement | Excel Worksheet Functions | |||
Formula Problem - If Statement | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
IF statement problem | Excel Worksheet Functions | |||
IF statement problem | Excel Worksheet Functions |