Audio CaptionStartStop

Creating Formulas Using the If Function

To use the IF Function:

  1. Select the cell in which you want to enter the function.
  2. Click the Insert Function button.
  3. Click IF from the list of functions.
  4. Click OK.
  5. Enter the Logical_test argument.
  6. Enter the Value_if_true argument.
  7. Enter the Value_if_false argument.
  8. Click OK.

The IF function will return one value if a condition is true and another value if the condition is false. Here a function is being entered that will return one value for a bonus if a certain quota is met and a different number for a bonus if the quota is not met.