On Thu, 12 May 2005 12:09:05 -0700, "David F"
wrote:
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
Assuming that is the only cell in which this is happening, the problem is that
Excel thinks your "formula" is a text string.
In the formula you posted, which has NO initial "=" but has an extraneous "="
sign in the middle of it, this is the expected result.
Try, in this order, doing the following:
1. Delete the contents of the cell.
2. Format/Cell/Number General
3. Reenter the formula: =IF(C380,ROUND(H38/C38,1),0)
Note the position of the one and only "=" sign.
--ron
|