Background
Data Analysis many times involves calculation of result based on slabs. Common use case scenario is the Grading System. Formulation of statement is sometimes a bit complex.
Many techniques are available for handling slabs as below
- Nested IF
- IFS function
Technique : Nested IF
=IF(B7>=90,"A",IF(B7>=80,"B",IF(B7>=70,"C","F")))
Marks:
Technique : IFS function
=IFS(B7>=90,"A",B7>=80,"B",B7>=70,"C",TRUE,"F")
Marks:
