As the title says, I'm trying to put a pay sheet together where there's tiers of bonus pay based off meeting a number of criteria. There are 4 categories and they are as follows,

Tier 1
20 flushes
20 alignments
55 tires
5 dealer changes

Tier 2
30 flushes
30 alignments
65 tires
5 dealer changes

Tier 3
35 flushes
35 alignments
75 tires
5 dealer changes

I want to have the numbers listed and the under the cells that have them listed, have the tier of bonus listed. I just don't know how to make a formula to tell me, based off the input numbers, whether it's tier 1, 2 or 3.

pay.jpg

Thanks