Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to write an IF-THEN formula in Excel and Google Sheets
Excel & Google Sheets
=IF(B2>=50, "Pass", "Fail")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Decide the test, e.g. is the score in B2 at least 50?
- 2Enter =IF(B2>=50, "Pass", "Fail").
- 3The cell shows "Pass" when true and "Fail" when false. Copy it down.
Tips
- For several conditions in order, use IFS instead of deeply nested IFs.
- Combine tests with AND/OR, e.g. =IF(AND(B2>=50, C2="Open"), "Yes", "No").
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I check more than one condition?
Nest AND or OR inside IF, e.g. =IF(AND(B2>0, C2="Open"), ...), or use IFS for several ordered conditions.