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

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

Many thanks. It did work.
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
add the '='.

Thsnks again,
David

"Ron Rosenfeld" wrote in message
...
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

On Thu, 12 May 2005 13:30:48 -0700, "David F"
wrote:

Many thanks. It did work.
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
add the '='.

Thsnks again,
David

I'm glad you got it working.

Yes there are some shortcuts that will sometimes work compared with the
instructions I posted.

Best wishes,


--ron