← 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:
- In C2, type
=IF(B2>=40,"Pass","Retake"). - Press Enter.
- Fill it down.
- 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
- IF function, Google Docs Editors Help.
- Logical Functions, LibreOffice Help.
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.
