Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David F
 
Posts: n/a
Default Fundamental problem with IF statement

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   Report Post  
Gary's Student
 
Posts: n/a
Default

use ROUND not =ROUND
--
Gary's Student


"David F" wrote:

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





  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Format your cell as General instead of Text. Delete the "=" before
ROUND() and reenter the formula.

In article ,
"David F" wrote:

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.

  #4   Report Post  
Gary's Student
 
Posts: n/a
Default

Also insure that the cell format is not forcing EXCEL to think it's text
--
Gary's Student


"David F" wrote:

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





  #5   Report Post  
David F
 
Posts: n/a
Default

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

"Gary's Student" wrote in message
...
Also insure that the cell format is not forcing EXCEL to think it's text
--
Gary's Student


"David F" wrote:

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - If Statement Margie Excel Worksheet Functions 4 April 29th 05 10:07 PM
How do I fix a circular reference in a financial statement? drjayhawk25 Excel Discussion (Misc queries) 0 February 7th 05 06:19 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
IF statement problem simon Excel Worksheet Functions 1 December 30th 04 11:59 AM
IF statement problem Kalabalana Excel Worksheet Functions 4 November 24th 04 09:37 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"