Spread Sheets‎ > ‎

### SS =If( , , )

 The IF StatementThe if statement can be used to perform a logical text as part of a complex formula in a spreadsheet.  Syntax=IF (Condition, TrueExpression, FalseExpression)Condition A logical expression representing the condition to be tested.TrueExpression A numeric or string value representing the value to use if Condition is true.FalseExpression A numeric or string value representing the value to use if Condition is false. Logical Operators:These are relational operators:<   >   <=   >=   <>   =   These are the boolean operators:Examples@IF(8=7,4,5) 5@IF(B4<100,"Yes","No") Yes if B4 < 100; otherwise, No@IF(C10=B5,45,50) 45 if C10 = the cell named B5; otherwise, 50Nesting @functionsAa @functionst can be placed inside of another @function.  When this is done it is call a nested  statement.  To nest a statement, just keep following the syntax rules of the statement, with on small exception.  The exception is that only one @ sign is needed for each formula.  Notice that each of these example will product the exact same results.  There is more than one correct approach to solving any problem.@IF(B4 = 70,”right on”, IF(B4<70,”too low”,”too high))@IF(B4 > 70,”too high”, IF(B4=70,”right on”,”too low))@IF(B4 < 70,”too low”, IF(B4>70,”too high,”too low))@IF(B4 = 70,”right on”, IF(B4>70,”too high,”too low))@IF(B4 >= 70, IF(B4>70,”too high,”right on”),too low)The easiest to keep the brackets and commas straight is to always type:  if bracket comma comma bracket ie If(      ,     ,    ) then keep filling in the parts of the funciton that need to be completed.You can nest as many functions as you like in a formula (up to 1022 characters), but it is more difficult to debug complex function formulas if there is a problem.This information originally from Quattro Pro Help