ExamFinch.com My Study

Study guide

Conditional Operations with IF

Practice this exam

Microsoft Excel Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Introduction & Exam Overview

About the MO-210 Exam Performance-Based Exam Strategy

2 Import Data & Navigate Workbooks

Import Data from Text Files Import Data from Online Sources Search and Navigate to Named Cells, Ranges, Elements Insert and Remove Hyperlinks

3 Format Worksheets, Views & Collaboration

Page Setup, Headers, Footers, Row Height & Column Width Quick Access Toolbar, Views, Freeze Panes, Properties, Display Formulas Print Area, Export Formats, Print Settings, Inspect, Comments & Notes

4 Manipulate Data in Worksheets

Paste Special and Auto Fill Insert and Delete Rows, Columns, and Cells Generate Numeric Data with RANDBETWEEN and SEQUENCE

5 Format Cells and Ranges

Merge, Alignment, Orientation, Indentation, Wrap Text Number Formats, Format Painter, Format Cells Dialog Cell Styles, Clear Formatting, Group Worksheets

6 Named Ranges & Visual Summaries

Define and Reference Named Ranges Insert and Manage Sparklines Apply and Remove Conditional Formatting

7 Create and Format Tables

Create Excel Tables from Cell Ranges Apply Table Styles and Convert Tables to Ranges Add or Remove Table Rows and Columns

8 Table Options, Filter & Sort

Configure Table Style Options Insert and Configure Total Rows Filter Table Records Sort Data by Multiple Columns

9 Formula References

Relative, Absolute, and Mixed References Structured References in Tables

10 Calculate and Transform Data

SUM, AVERAGE, MIN, and MAX COUNT, COUNTA, and COUNTBLANK Conditional Operations with IF SORT and UNIQUE Functions

11 Format and Modify Text

LEFT, RIGHT, and MID UPPER, LOWER, LEN, CONCAT, and TEXTJOIN

12 Create Charts

Create Charts from Data Create Chart Sheets

13 Modify and Format Charts

Add Data Series and Switch Rows/Columns Add and Modify Chart Elements Chart Layouts, Styles, and Alternative Text

Conditional Operations with IF

Key Takeaways Explain This Topic AI

IF tests a condition and returns one value when TRUE and another when FALSE: =IF(logical_test, value_if_true, value_if_false)

Logical tests use comparison operators such as =, <>, >, <, >=, and <= between cells, numbers, or text

Text results in IF must be quoted; numeric results and cell references are written without extra quotes

Nested IF is acceptable in light Associate scenarios (two or three outcomes); IFS is an Expert-level contrast, not the MO-210 focus

Fill IF formulas with relative references for the tested cell and absolute references for fixed thresholds when required

Last updated: August 2026

Conditional operations on MO-210

The Calculate and transform data objective includes conditional operations using IF . At Excel Associate (MO-210) level, you write formulas that branch: if a test is true, show one result; otherwise show another. You are not building Expert dashboards with IFS, SWITCH, or deep nested trees—those belong more to MO-211 territory. Know IF thoroughly; nest only lightly when a project needs a third outcome.

Task language sounds like "In column E, display Pass if the score is 70 or higher; otherwise display Fail" , "Show Bonus if sales exceed the quota in H1; otherwise show 0" , or "Return Yes when Quantity is greater than ReorderLevel." Graders look for a correct IF structure in the formula bar, not only a coincidentally correct static label.

IF syntax

  • Part Role Example
  • logical_test Condition that evaluates to TRUE or FALSE B2>=70
  • value_if_true Result when the test is TRUE "Pass"
  • value_if_false Result when the test is FALSE "Fail"
  • Full form: =IF(logical_test, value_if_true, value_if_false)
  • Example: =IF(B2>=70,"Pass","Fail")

If B2 is 85 , the cell shows Pass . If B2 is 62 , it shows Fail .

Comparison operators for logical tests

  • Operator Meaning Example test
  • = Equal to A2="NY"
  • <> Not equal to C2<>0
  • > Greater than D2>100
  • < Less than D2<0
  • >= Greater than or equal to B2>=70
  • <= Less than or equal to E2<=50

Text in tests and text results needs quotation marks: "Pass" , "NY" . Numbers do not: 70 , 0 . Cell references are bare: B2 , $H$1 .

Worked example: pass / fail

  • A (Student) B (Score) C (Result)
  • 1 Student Score Result
  • 2 Ana 88 =IF(B2>=70,"Pass","Fail")
  • 3 Ben 65 fill from C2
  • 4 Cai 70 fill from C2

After fill:

  • C2 → Pass
  • C3 → Fail
  • C4 → Pass (70 meets >= )

Using > instead of >= would incorrectly fail a score of exactly 70—read the project wording ("70 or higher" vs "above 70").

Worked example: numeric outputs and absolute thresholds

Quota lives in H1 as 5000 . Column B has sales; column C should show a $200 bonus when sales meet or exceed the quota, otherwise 0 .

In C2: =IF(B2>=$H$1,200,0)

Fill down. $H$1 stays locked so every row compares to the same quota. If you wrote H1 without dollars and filled down, lower rows would compare to H2, H3, and so on—classic reference mistake mixed into an IF task.

You can also return a calculated value: =IF(B2>=$H$1,B2*0.05,0)

True branch: five percent of that row's sales. False branch: zero.

  • Worked example: text status from inventory
  • Reorder when on-hand quantity in B2 is less than or equal to reorder level in C2: =IF(B2<=C2,"Reorder","OK")

Both sides of the test can be cell references. No absolute locks needed if each row has its own reorder level and you fill down relatively.

Filling IF down a column

Write the IF correctly in the first data row.

Decide which references must be absolute (shared rate, quota, passing score in one cell).

Fill or double-click the fill handle.

Spot-check a TRUE row and a FALSE row, and open Show Formulas to confirm $ signs.

IF does not auto-expand like a dynamic array; it is a normal scalar formula per cell—exactly what Associate projects expect for status columns.

Light nesting (Associate only)

Sometimes a project needs three labels, such as High / Medium / Low. A nested IF places another IF in the false (or true) branch: =IF(B2>=90,"High",IF(B2>=70,"Medium","Low"))

Evaluation order:

  • If score ≥ 90 → High
  • Else if score ≥ 70 → Medium
  • Else → Low

Keep nesting shallow (two IF levels is enough for Associate). Deep nests are hard to grade and rare on MO-210.

Brief contrast: IFS (not the MO-210 focus)

Microsoft 365 also offers IFS , which lists condition/result pairs: =IFS(B2>=90,"High",B2>=70,"Medium",TRUE,"Low")

Know that IFS exists so you are not confused if you see it in help docs—but for Exam MO-210, prefer standard IF (and light nesting) unless a task explicitly names IFS. Do not rewrite every IF as IFS "to be modern"; the Associate objective calls out IF.

  • Combining IF with aggregates
  • Flag values above the column average: =IF(B2>AVERAGE($B$2:$B$20),"Above avg","OK")

Or count-related logic using a helper column of IF results, then COUNTA on "Yes" labels—though many projects only ask for the IF column itself.

Boolean tests can compare to COUNT results too: =IF(COUNT(D2:D20)>=10,"Enough scores","Need more")

That single-cell summary IF sits outside the data block and still uses Domain 4 counting skills.

Quotes, blanks, and data types

=IF(A2="","Missing","Present") tests for a blank cell.

Returning "" (empty text) hides a false branch: =IF(B2>=70,"Pass","") .

Do not write =IF(B2>=70,Pass,Fail) without quotes—Excel treats unquoted Pass/Fail as names and often returns #NAME? .

Mixing numbers and text in outputs is fine: true → "Qualified" , false → 0 .

Common MO-210 traps

Forgetting quotes around text results → #NAME? .

Using = when the English says "at least" ( >= ) or "more than" ( > ).

Leaving a quota cell relative when filling IF down.

Nesting five levels or switching to IFS when the project asked for IF.

Typing the true and false values in the wrong order (fail-first logic).

Comparing text numbers incorrectly when a cell is text-formatted—ensure scores are numeric if you use >=70 .

Practice sequence

Build Pass/Fail with >=70 ; test scores 69, 70, and 95.

Add a quota in H1; write bonus IF with $H$1 ; fill and break it once on purpose without $ to see the failure mode.

Write a two-level nested IF for High/Medium/Low and rewrite the same logic mentally as IFS—then stick with IF for exam practice.

Combine B2>AVERAGE($B$2:$B$15) inside IF and fill a flag column.

Solid IF skills—tests, quotes, fill locks, and light nesting—complete the conditional half of Calculate and transform data for MO-210.