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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
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 |