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
|