View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rod from Corrections Rod from Corrections is offline
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!!!