Hands-On Lab: IF Function in Excel

⏳ Duration: 2 Hours

🎯 Level: Beginner – Intermediate

🧠 Method: Brief explanation & hands-on practice

📦 Material Format: Interactive (usable offline/online)

📌 Prerequisites: Familiar with entering data and basic Excel formulas

🎯 Objective: Participants can use the IF function to create simple logic in Excel data.

Welcome to TTC Hands-On Lab! In this exercise, we will learn the **IF function** in Excel. This function is useful for making automatic decisions based on certain conditions, such as pass/fail, safe/out-of-stock, or grading categories.

🧩 Case Study

You have the following student scores table:

      | Name | Score |
      |------|-------|
      | Asep | 60    |
      | Budi | 59    |
      | Cici | 45    |
      | Dedi | 30    |

Goal: create an automatic **Remarks** column using the IF function:

Score ≥ 60: Write "Pass"
Score < 60: Write "Remedial"

✨ Steps

Add a new column Remarks next to the Score column.
Select the first cell in Remarks (e.g., C3).
Enter the formula:
```
=IF(B3>=60,"Pass","Remedial")
```
Press Enter, then drag the fill handle down to apply to all rows.

💡 Important Notes

The IF function evaluates a logical condition (example: B3>=60).
The second part is the value if the condition is TRUE (e.g., "Pass").
The third part is the value if the condition is FALSE (e.g., "Remedial").
You can add nested IFs for more than 2 conditions, e.g., A/B/C/D grading.

Entering IF formula in Excel — Enter the IF formula in the Remarks cell.

Result of IF formula in Excel — Automatic result: "Pass" or "Remedial" based on the student's score.

📝 Exercise:

Create a sales table of 10 products with a Quantity Sold column.
Add a Status column and use IF to mark "Safe" if ≥50, and "Out of Stock" if <50.
Try modifying with nested IFs to add a "Almost Out" category.

Want to Learn Excel and Computer Skills for Free?

Visit our complete guide and join TTC’s free classes:

📘 Complete Excel Tutorial 📚 See Other Tutorials 🧪 Other Hands-On Labs ✅ Register Now for Free