Skip to content

← Using a Computer, in Practice

Spreadsheets · 59 of 111

Let IF write the answer for you

Expert guidance

Do this

With a mark in B2, and a pass mark of 40:

  1. In C2, type =IF(B2>=40,"Pass","Retake").
  2. Press Enter.
  3. Fill it down.
  4. Change a mark and watch it change.

Same in LibreOffice Calc, Google Sheets and Excel.

Why this way

It has three parts inside the brackets: the test, what to show if it’s true, and what to show if not. Words go in straight quote marks. If a formula shows an error, check its brackets and commas first. Your school’s real pass mark may differ, so put yours in. Expert guidance.

Do it today

Add a Pass or Retake column to a marks list. Five minutes.

Where these facts come from

General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.

← All 111 things to do