Fundamental problem with IF statement

  • Thread starter Thread starter David F
  • Start date Start date
D

David F

I have the following statement in cell E38:
IF(C38>0,=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
 
Format your cell as General instead of Text. Delete the "=" before
ROUND() and reenter the formula.
 
Sorry, it did eventually worked.
Interestingly, I did try first =IF(..., but because it depends on another
cell where I had an 'IF(...' (w/o the '=') it gave me an #VALUE! which I did
not trace so I gave up on the '=IF(...' too early...
FYI, I did not need to reenter the entire statement. It is enough if I just

Thanks again,
David
 
Back
Top