Explanation
A Nested IF means placing one IF function inside another IF.
It is useful when multiple conditions need to be checked and IFS is not being used.
Syntax
=IF(condition1,result1,IF(condition2,result2,result3))
Example — Employee Performance
|
Employee |
Sales |
Rating |
|
Amit |
125000 |
|
|
Neha |
95000 |
|
|
Rahul |
65000 |
|
|
Priya |
35000 |
Formula:
=IF(B2>=100000,”Excellent”,IF(B2>=75000,”Good”,IF(B2>=50000,”Average”,”Needs Improvement”)))
Result
|
Employee |
Sales |
Rating |
|
Amit |
125000 |
Excellent |
|
Neha |
95000 |
Good |
|
Rahul |
65000 |
Average |
|
Priya |
35000 |
Needs Improvement |
Practice
Create a salary-based bonus classification using Nested IF.