3.13 IF, Nested IF and IFS
=IF(logical_test, value_if_true, [value_if_false])
| Goal | Formula | Row 11 result |
|---|---|---|
| Late or on time | =IF(H2>15,"Late","On time") |
Late (17 mins) |
| Delivery fee: free above ₹199 | =IF(G2>=199,0,25) |
25 |
Nested IF (एकात एक गुंफलेले IF) – an IF inside another IF – for more than two outcomes:
=IF(G2>=1000,"Premium",IF(G2>=200,"Regular","Small"))
IFS (Excel 2019+) is easier to read: tests are checked in order and the first TRUE wins.
=IFS(G2>=1000,"Premium", G2>=200,"Regular", TRUE,"Small")
| Amount | Result |
|---|---|
| 1,299 | Premium |
| 270 | Regular |
| 90 | Small |
Ravindra Bagale's Tip
Nested IF madhe conditions chi order chukli ki result chukta – khup students G2>=200 aadhi lihitat, mag ₹1,299 la pan "Regular" yeta. Motthya value pasun lahan kade (kiwa ulta) ekach disha theva. IFS madhe shevti TRUE ghala, nahitar koni match nasel tar #N/A yeto. 4-5 peksha jast levels asle tar lookup table (Module 4) vapra.
Practice task
Bonus for store managers: 10% of sales if sales > ₹1,00,000, else 5% (this style of question is reported in interviews – see Module 18). Grade delivery time: ≤ 10 Excellent, ≤ 15 Good, else Needs Improvement.