What you will build

Label each order Large when Units is at least 3; otherwise Standard.

Learning objective

Enter the formula in a blank output area, understand every argument, compare the result with the visible source data and diagnose range or criterion mistakes.

Open the practice workbook

Use the sample below and keep the full source table visible while checking the result.

HANDS-ON PRACTICE

Practice in your own copy

Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.

Make a Google Sheets copy (access required) ↗View original

Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.

Complete Google Sheets source table before formula verification.

Hands-on practice

Step 1: Add a label column G and enter =IF(D2>=3,"Large","Standard") in G2.

=IF(D2>=3,"Large","Standard")
The result cell is selected with the formula visible in the formula bar and the complete source table available for comparison.

Step 2: Copy the formula through G6 and compare each label with Units in column D.

Checkpoint

UnitsExpected label
2Standard
3Large
1Standard
4Large
2Standard

G2:G6 should read Standard, Large, Standard, Large, Standard.

Common mistakes and fixes

Correction: return to the exact range and command named in the steps, then compare the live sheet with the Units, Expected label source fields.

Independent practice

Change one relevant input deliberately, predict the new result first, verify it in Sheets, then restore the original sample.

Key takeaways

  • ✓Complete “IF function” using the visible Units, Expected label sample so each action and the final state can be checked against the source data.
  • ✓Add a label column G and enter =IF(D2>=3,"Large","Standard") in G2.
  • ✓Copy the formula through G6 and compare each label with Units in column D.
  • ✓If the result differs, repeat “Add a label column G and enter =IF(D2>=3,"Large","Standard") in G2.” and then “Copy the formula through G6 and compare each label with Units in column D.”. Verify the working table still uses Units, Expected label before changing source values.
  • ✓Change one relevant input deliberately, predict the new result first, verify it in Sheets, then restore the original sample.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. What is the correct first action in “IF function”?
2. Which follow-up action belongs to “IF function”?
3. What should you verify before “IF function” is complete?
4. Which correction is appropriate if “IF function” behaves unexpectedly?

Continue learning

Next lesson: IFS function.