The IF Statement The 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, 50 Nesting @functions Aa @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 |
Spread Sheets >