Home Courses Microsoft Excel Day 15: IF Function — Introduction
WEEK 3 DAY 15 OF 30 60 MINUTES WORKBOOKS INCLUDED

Day 15: IF Function — Introduction

Add logic and intelligence to your sheets: learn =IF(logical_test, value_if_true, value_if_false).

Easy-Learn Framework

Mastering Day 15: What, Why & How

Memory Rule Included
Day 15: IF Function — Introduction Visual Diagram
? WHAT Is It?

The smart decision-maker of Excel. It evaluates a condition: IF the condition is TRUE it returns one result; IF the condition is FALSE it returns another. Formula: =IF(condition, value_if_true, value_if_false).

! WHY Does It Matter?

Eliminates manual human evaluation. Automatically flags Pass/Fail for student scores, Approved/Rejected for credit, or calculates bonus payouts across thousands of rows instantly.

⚙ HOW Does It Work?
Step 1 Write condition: =IF(C2 >= 40, 'Pass', 'Fail').
Step 2 Rule for Text: Any text output MUST be enclosed in double quotation marks ('Pass'). Numbers do NOT need quotes.
Step 3 Use logical comparison operators: > (greater), < (less), >= (greater/equal), <= (less/equal), = (equal), <> (not equal).
Memory Hook & Golden Rule (Remember This Forever):

"IF is a 3-part sentence: 1. Condition, 2. Reward if True, 3. Result if False. Always put words in double quotes!"

Learning Objectives

What You Will Master Today

  • Anatomy of the IF function: Logical Condition, True Outcome, False Outcome
  • Relational comparison operators: >, <, >=, <=, =, <>
  • Handling text outputs: Always wrap text strings in quotation marks (e.g., "Pass", "Fail")
  • Handling numeric outputs: Do NOT wrap numbers in quotes (e.g., 0, 500)
Important Keyboard Shortcuts:
=IF(test, true, false)> (Greater Than)< (Less Than)>= (Greater Equal)<= (Less Equal)<> (Not Equal)
Guided Tutorial

Step-by-Step Practical Walkthrough

Step 1

Identify your condition: e.g., 'Is Student Marks >= 40?'

Step 2

Type '=IF(C5>=40, "Pass", "Fail")'.

Step 3

Press Enter and copy down: any score 40 or higher displays 'Pass', below 40 displays 'Fail'.

Step 4

Change a score from 35 to 65 and watch the result update from 'Fail' to 'Pass' automatically!

Solved Classroom Example

Uttarakhand Board Exam Result Portal - Pass / Fail Automated Validator

Pre-filled Data & Answers

Study the completed reference worksheet below. Every column illustrates the standard formatting, formula structure, and alignment applied by professional office operators.

Roll NoCandidate NameTotal Score (100)Passing MarkResult StatusGrade Status
UK-401Rohit Joshi7833PassQualified
UK-402Priya Rawat2933FailNeeds Improvement
UK-403Aman Bisht8533PassQualified
UK-404Kavita Pandey3133FailNeeds Improvement
UK-405Suresh Negi6233PassQualified
Download Solved Sample Sheet Includes complete working formula cells, proper currency symbols, and clean borders.
Download Solved Sheet (.xlsx)
Student Assignment

E-Commerce Customer Order Dispatch Eligibility

Your Turn to Practice
Exercise Tasks Checklist:
  • Task 1: In Column E (Shipping Status), write an IF formula: if Payment Received = 'Yes', return 'Dispatch Order', otherwise 'Hold Payment Pending'.
  • Task 2: Formula to write: '=IF(D5="Yes", "Dispatch Order", "Hold Payment Pending")'.
  • Task 3: Copy the formula down to all order rows.
  • Task 4: Change row 6's payment status to 'Yes' and observe the status flip automatically.

Exercise Data Template Preview: Download the .xlsx file below and execute each task independently.

Order IDCustomer NameOrder Value (₹)Payment Received?Shipping Status
ORD-901Verma Traders₹14,500.00Yes
ORD-902Kumaon Handlooms₹8,200.00No
ORD-903Haldwani Mart₹22,000.00Yes
ORD-904Pooja Boutique₹6,500.00No
ORD-905Nainital Gifts₹11,800.00Yes
Download Practice Exercise Sheet Pre-structured practice workbook with raw datasets ready for hands-on classroom lab solving.
Download Practice Sheet (.xlsx)
Mentor Pro Tip from Haldwani Classroom Lab:

Always wrap text strings in quotation marks inside IF statements: "Pass". If you type Pass without quotes, Excel gives a '#NAME?' error searching for a formula named Pass!

Day 14: Formula Practice and R... All 30 Topics Day 16: AND, OR and Multiple C...

Need 1-on-1 Guidance on Day 15?

Join our hands-on classroom lab sessions at Digital Skills Academy in Haldwani. Every student receives a dedicated PC workstation, live instructor reviews, and interview prep.