Hi,

I need a quicker and smarter formula for my incentive calculation, but all I can think of is IF IF IF, and I realized that moving forward, there are going to have more IFs if the incentive tier is increasing.

I have paste the attachmentTier_Sample.xlsx

Here is my explanation:

Under the cell IDS, LP , SP ,

If all of them are Tier 2, Result shows Tier 2
If 1 of the cell has Tier 1, Result shows Tier 1
If 1 of the cell has NO, Result shows NO (Regardless there are Tier 1 or Tier 2 exist)

Currently I'm using IF IF IF

Hope Anyone can suggest me any better Formulas that this

Thank you

Regards,
Richard