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.