LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Nested IF statements

I am very new to this and need some help with the syntax for nested IF
functions, please.

Here is what I am trying to achieve:

Display in cell E2:
1) if there is no value in cell D2, blank (zero).
2) if the value in cell C2 is greater than the value in cell H3, display the
value of cell C2 divided by four and then multiplied by the value in cell H11
[(C2/4)*H11]
3) if the value in cell C2 is less than the value in cell H3 but expressed
as a negative number, then display the value of cell C2 divided by four and
then multiplied by the value in cell H11 [C2/4)*H11].
4) If neither condition 2 or 3 is true, then display blank (zero).

Please help!!!
 
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
Nested if statements JBS Excel Worksheet Functions 2 March 6th 09 05:45 PM
Nested IF statements using AND / OR Joe[_13_] Excel Worksheet Functions 2 February 9th 09 06:14 PM
Nested IF statements Karrisac15 New Users to Excel 1 July 19th 07 08:06 PM
Nested IF Statements Django Excel Discussion (Misc queries) 2 March 4th 06 01:44 AM
what is the max no. of nested Ifs can an If Statements have in EXC StevenE Excel Discussion (Misc queries) 1 June 27th 05 03:03 PM


All times are GMT +1. The time now is 03:59 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"