Your manager asks you to mark each employee as “Met Target” or “Below Target”. You could check each row manually, but that becomes slow and error-prone. The IF function lets Excel make the decision for every row.

What does the IF function do?

The IF function checks a condition and returns one result when the condition is true, and another result when the condition is false.

Simple rule: Use IF when your Excel logic sounds like “if this happens, show this; otherwise show that.”

IF formula syntax

Formula structure

=IF(logical_test, value_if_true, value_if_false)

Example: =IF(D4>=C4,"Met Target","Below Target")

This checks whether Actual Sales is greater than or equal to Monthly Target. If yes, Excel returns “Met Target”. If no, it returns “Below Target”.

Business examples

ScenarioFormulaResult
Target achieved=IF(D4>=C4,"Met Target","Below Target")Met Target
Bonus eligibility=IF(D4>=C4,"Yes","No")Yes
Attendance review=IF(H4>=90%,"Good","Needs Review")Good
IFOne condition
ANDAll conditions true
ORAny condition true

IF with AND and OR

IF with ANDUse when all conditions must be true. Example: target met and attendance good.
IF with ORUse when any one condition can trigger the result. Example: urgent or below target.
💡
Professional habit: Test your IF formula with both true and false examples before copying it to all rows.
⚠️
Common mistake: Forgetting quotation marks around text results like "Yes", "No", or "Below Target".
🧪 Practice Lab

Build employee performance decisions

Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, formula cheat sheet, quiz and answer key.

📦 Download Lesson 15 ResourcesWorks as a standalone file and after website deployment

Mini assignment

  1. Calculate Variance as Actual Sales minus Monthly Target.
  2. Use IF to return Met Target or Below Target.
  3. Use IF to return Bonus Eligible Yes or No.
  4. Use IF to review attendance.
  5. Use IF with AND for Final Remark.

Quick quiz

  1. What does IF do?
  2. What are the three parts of IF?
  3. Why do text outputs need quotation marks?
  4. What does AND require?

Answers: Checks condition and returns different results; logical test, true result, false result; Excel treats them as text; all conditions must be true.

FAQ

Yes. IF can return text, numbers, formulas or even blank values.
Yes. IF is commonly used for status labels, eligibility checks, exception flags and performance reviews.