IF Function continued...


Greater than >

graphic of school test grades

  1. Click on cell G6
  2. Click graphic of Insert Function button
  3. In the box under Function name, click IF.
  4. Click OK.
  5. You see this box:

    graphic of function IF box
  6. Click in the box beside Logical_test
  7. Type F6>60
  8. This means if F6 is more than(>) 60.
  9. Click in the box beside Value_if_true.
  10. Type passed.
  11. Click in the box beside Value_if_false.
  12. Type failed.
  13. Click OK.
  14. In the formula bar, you will see the function:

    =IF(F6>60, "passed", "failed").

    If F6>60 is true, Luis passed.

    If F6>60 is false, Luis failed.

  15. Right click on cell G6.
  16. Click Copy.
  17. Select G7:G9.
  18. Click Paste.