Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 05, 08:44 PM
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)
E38's format is 'General'.
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 is 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  
Old May 12th 05, 09:10 PM
JE McGimpsey
 
Posts: n/a
Default

You had two people answer you yesterday. If those answers didn't help,
mention why in your post rather than simply reposting.

If you can't find your post, you can always look it up in the archives:

http://groups.google.com/advanced_gr...ugroup=*excel*

Use your name or email address in the Author field.

Just one other question - do you have an "=" sign at the beginning of
your formula?


In article ,
"David F" wrote:

I have the following statement in cell E38:
IF(C380,ROUND(H38/C38,1),0)
E38's format is 'General'.
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 is 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  
Old May 12th 05, 09:18 PM
Duke Carey
 
Posts: n/a
Default

Sounds like E38 is formatted as Text. Select E38, press Ctrl-1, and choose
General from the number tab.

"David F" wrote:

I have the following statement in cell E38:
IF(C380,ROUND(H38/C38,1),0)
E38's format is 'General'.
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 is 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



  #4   Report Post  
Old May 17th 05, 03:42 PM
Safu
 
Posts: n/a
Default

Sound like you left "=" infront of your formula which will show you the
incomplete formula instead of doing your calculation.

"David F" wrote:

I have the following statement in cell E38:
IF(C380,ROUND(H38/C38,1),0)
E38's format is 'General'.
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 is 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
Fundamental problem with IF statement-None worked David F Excel Worksheet Functions 3 May 13th 05 12:37 AM
Fundamental problem with IF statement David F Excel Worksheet Functions 4 May 12th 05 09:34 PM
Formula Problem - If Statement Margie Excel Worksheet Functions 4 April 29th 05 10:07 PM
IF statement problem simon Excel Worksheet Functions 1 December 30th 04 10:59 AM
IF statement problem Kalabalana Excel Worksheet Functions 4 November 24th 04 08:37 PM


All times are GMT +1. The time now is 04:22 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017