Hello Experts!

I am trying to calculate the incentive (

Though I can get it to calculate for the ONE criteria, I'm stuck trying to nest the IF and ANDs. I tried Google and other sites that suggest a solution, but I'm either too stupid to figure it out, or it doesn't cover enough tiers.

Would love to have a helping hand figuring this out.

Much thanks in advance.

Nat

I am trying to calculate the incentive (

**Points Accrued**in the attached Excel file) for a staffer, based on the**number of chats**he handles for a particular**channel count**.Though I can get it to calculate for the ONE criteria, I'm stuck trying to nest the IF and ANDs. I tried Google and other sites that suggest a solution, but I'm either too stupid to figure it out, or it doesn't cover enough tiers.

Would love to have a helping hand figuring this out.

Much thanks in advance.

Nat

## Comment