IF Function in Apple Numbers: Syntax, Examples and Troubleshooting
A practical Apple Numbers IF guide with exact syntax, verified documentation, worked results and common pitfalls.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked
IF function in Apple Numbers
Quick answer: Use =IF(B2>=60,"Pass","Review") to convert a numeric score into a clear status.
Use this function when you need to return one result when a test is true and another when false. The data below are original tutorial examples; expected answers were independently reasoned from the supplied rows, not obtained by running Numbers.
Syntax and argument definitions
=IF(if-expression, if-true, if-false)
| Argument | Apple Numbers meaning and requirements |
|---|---|
if-expression |
A logical test returning TRUE or FALSE; Numbers also treats numeric zero as FALSE and other numbers as TRUE. |
if-true |
Value, text, formula or reference returned when the expression is TRUE. |
if-false |
Optional value returned for FALSE. Apple documents that completely omitting it returns FALSE on a false test; leaving an empty trailing slot returns 0. |
The placeholder names and ordering above follow Apple’s IF reference, checked 2026-10-10 America/Toronto (2026-10-11 UTC). Apple’s English examples use comma-separated arguments. If input parsing differs for your locale, use the in-app function browser to insert the function and select ranges instead of guessing separators.
Reproduce the worked example
In Numbers, create a new table named Example. Put the headings in row 1, add the following exact data in the corresponding row numbers, and enter the formula in an empty result cell outside the source ranges.
| Row | A: Student | B: Score | C: Submitted |
|---|---|---|---|
| 2 | Avery | 78 | Yes |
| 3 | Blake | 49 | No |
| 4 | Casey | 93 | Yes |
| 5 | Dana | 60 | Yes |
| 6 | Ellis | 58 | Yes |
=IF(B2>=60,"Pass","Review")
Expected output: Pass.
How to check the result: 78 meets the threshold of at least 60, so Numbers returns the if-true text.
More advanced scenario
With the same data table, enter:
=IF(AND(B5>=60,C5="Yes"),"Eligible","Hold")
Expected output: Eligible.
Dana has score 60 and Submitted=Yes, so both AND conditions are true and the eligible branch is selected.
For formulas in a different table, let the Numbers formula editor insert the correct cross-table references; do not blindly paste Excel sheet syntax into a Numbers document.
Limitations, edge cases and errors
Tests are evaluated as Booleans. Text outputs require quotes. A missing false branch has special behavior: IF(test,result) may return logical FALSE when the test fails, while an empty argument position has different behavior. For more than two states, prefer IFS or a well-ordered nested IF.
Troubleshooting checklist
If every row receives the same result, ensure relative references moved with the row. Check comparisons such as >= versus > and place text criteria inside double quotes. If an input could be absent, decide explicitly whether blank means zero or unknown.
If an input is absent or text where a numeric value is required, check the cell’s actual value type, not only its visual number format. Remove downstream error-handling wrappers temporarily when diagnosing a hidden calculation problem.
macOS, iPhone and iPad: version-aware notes
Apple documents these named functions in the shared Formulas and Functions Help, accessible when using Numbers and other iWork table editors. This source check confirms the syntax in the documentation available on the check date, not a specific minimum release version. The checked pages did not establish an introductory app version or a macOS-versus-iOS formula difference for this function; do not claim historical or device-specific parity without testing the actual installed versions. Entry workflow and localised punctuation may differ, so follow the platform’s Functions Browser if typing directly fails.
Excel, Google Sheets and LibreOffice Calc
Excel, Google Sheets and LibreOffice Calc have an IF function, but branch omission, separators and coercion rules deserve a separate check on imported workbooks. Numbers allows cell references that include a table name.
Related Apple Numbers guides
Official reference and verification
Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.
- No genuine Apple Numbers screenshots are included; this guide does not use mock application images.