Introduction to Excel IF Function
Practice problems Excel free download for IF function are essential for mastering logical testing in spreadsheets. These exercises cover real-world scenarios like overdue invoices, discounts, grades, and payments. This guide provides 20 step-by-step problems with solutions, helping beginners and professionals strengthen their Excel IF function skills.
In this article, you’ll learn:
- The syntax of the IF function.
- 20 real-world problems and solutions you can practice.
This step-by-step guide is designed for beginners and professionals who want to master logical testing in Excel.
Excel IF Function Syntax with Example
The IF function checks whether a condition is true or false, then returns a result accordingly:
=IF(logical_test, value_if_true, value_if_false)
- logical_test → The condition to check (e.g., A2>50).
- value_if_true → The result if the condition is TRUE.
- value_if_false → The result if the condition is FALSE.
Example:
=IF(C2>B2,"Overdue","On Time")
Returns Overdue if Payment Date is later than Due Date, otherwise On Time.
Example Dataset (included in XLS file)
| Invoice ID | Due Date | Payment Date | Amount | Marks | Hours Worked | Bonus |
|---|---|---|---|---|---|---|
| 101 | 2025-08-01 | 2025-08-05 | 500 | 78 | 42 | Yes |
| 102 | 2025-08-10 | 2025-08-08 | 750 | 55 | 38 | No |
| 103 | 2025-08-12 | — | 900 | 92 | 45 | Yes |
| 104 | 2025-08-15 | 2025-08-15 | 0 | 30 | 40 | No |
| 105 | 2025-08-20 | — | 1200 | 85 | 50 | Yes |
Excel IF Function Problems and Solutions (20 Real Examples)
- Flag overdue invoices
=IF(C2>B2,"Overdue","On Time") - Mark unpaid invoices as “Pending”
=IF(C2="","Pending","Paid") - Check if Sales > 1000 → “High” else “Low”
=IF(D2>1000,"High","Low") - Student Pass/Fail (>=40 Pass)
=IF(E2>=40,"Pass","Fail") - Apply 10% discount if Amount > 500
=IF(D2>500,D2*0.9,D2) - Mark Attendance (P for ≥75%, else F)
=IF(E2>=75,"P","F") - Check if Delivery Date > Due Date → “Late”
=IF(C2>B2,"Late","On Time") - Flag orders less than 100 as “Small”
=IF(D2<100,"Small","Normal") - Check if Payment = blank → “Unpaid”
=IF(ISBLANK(C2),"Unpaid","Paid") - Multiple IF: Grade (>=90 A, >=75 B, else C)
=IF(E2>=90,"A",IF(E2>=75,"B","C")) - Highlight weekend dates
=IF(WEEKDAY(B2,2)>5,"Weekend","Weekday") - Return “Bonus” if Sales ≥5000, else “No Bonus”
=IF(D2>=5000,"Bonus","No Bonus") - Employee Overtime (>40 hrs)
=IF(F2>40,"Overtime","Normal") - Return “Expired” if Today > Due Date
=IF(TODAY()>B2,"Expired","Valid") - Flag zero sales as “No Sales”
=IF(D2=0,"No Sales","Recorded") - Check if ID starts with 1 (Text LEFT function)
=IF(LEFT(A2,1)="1","Group 1","Other") - Tax Rate: If Income >50,000 → 20%, else 10%
=IF(D2>50000,0.2,0.1) - Check if Bonus = “Yes” → Extra 100 added
=IF(G2="Yes",D2+100,D2) - Return “Duplicate” if Name already appears
=IF(COUNTIF(A$2:A2,A2)>1,"Duplicate","Unique") - Nested IF with Status
=IF(C2="","Pending",IF(C2>B2,"Overdue","On Time"))
Why Practice Excel IF Function Problems Helps You Learn Faster
- Real business datasets, not just theory.
- Step-by-step problems and solutions.
- Covers basic, intermediate, and advanced IF scenarios.
- Hands-on practice ensures you master logical testing in Excel.
Download Excel IF Function Problems and Solutions XLS File
- Download and practice the Excel IF function file.
- Try solving without looking at the solutions first.
- Move on to advanced formulas like IFS, SWITCH, and nested IF with AND/OR.
By the end, you’ll be confident in applying IF function logic to invoices, reports, HR sheets, budgets, and more.
