I need help. Im trying to put my jobs production incentive pay on a
spreadsheet. I need a funtion for this:
10000 or higher = 65% of $160 which is $104
9000-9999 = 50% of $160 which is $80
8000-8999 = 35% of $160 which is $56
7000-7999 = 20% of $160 which is $32
6000-6999 = 10% of $160 which is $16
0-5999 = 0% of $160 which is $0

Please help!!