🧠 LEVEL 4: LOGICAL & LOOKUP FUNCTIONS

🔷 PART A: LOGICAL FUNCTIONS

1️⃣ IF Function (MOST IMPORTANT)

📌 Theory

The IF function checks a condition and gives one result if TRUE, another if FALSE.

📐 Syntax

=IF(condition, value_if_true, value_if_false)

✅ Example 1: Pass / Fail

A (Marks)

35

60

80

Condition:

• Marks ≥ 40 → Pass