LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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)
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


 
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 11:50 AM.

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

About Us

"It's about Microsoft Excel"