graphic of fancy bullet

Practice Activity
IF Function



graphic of fancy bulletActivity #1

  1. Open a new workbook.
  2. Create this using what you have learned:

    graphic of real estate agents' sales practice table
  3. Type a formula in cells G4:G7 to find the total house sales of each person.
  4. Type an IF Function in cells H4:H7. First in the box beside Logical Test, type G4>=1,000,000
  5. In the box beside Value_if_true, type The winner.
  6. In the box beside Value_if_false, type No.
  7. Copy the function and paste it in cells H5:H7.
  8. Save as IF Function1.
  9. Close.