Now we will combine different functions to create professional formulas.

Example 1 — Pass/Fail

=IF(AND(B2>=40,C2>=40),”Pass”,”Fail”)

Example 2 — Bonus Eligibility

An employee will receive a bonus if:

Sales ≥ ₹1,00,000 OR Performance ≥ 90

=IF(OR(B2>=100000,C2>=90),”Bonus”,”No Bonus”)

Example 3 — Attendance Status

If attendance is 75% or more:

=IF(B2>=75%,”Eligible”,”Short Attendance”)

Example 4 — Error Handling

=IFERROR(B2/C2,0)

Example 5 — Grade

=IFS(B2>=90,”A+”,B2>=75,”A”,B2>=60,”B”,B2>=40,”C”,TRUE,”Fail”)

Here, the final TRUE works like a default condition for all remaining cases.