I need a difficult function

[ebank23]

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!!

 

[JE McGimpsey]

One way:

=160*LOOKUP(A1,{0,6000,7000,8000,9000,10000},{0,0.1,0.2,0.35,0.5,0.65})

 

[ebank23]

Thanks. Believe it or not ive been working on this for 2 days. Its amazing
how intelligent some people are. Thanks again!

 

[Keith Faulconer]

The easiest is probably a nested if statement:

=if(a1<6000,0,if(a1<7000,16,if(a1<8000,32,if(a1<9000,56,if(a1<10000,80,104)))))

Hope that works!

 

[Dana DeLouis]

I just edited some changing to a program I have, and I'm testing it on
your problem. One of the suggestions was...

=MOD(47793872,4*MEDIAN(5,INT(A1/1000),10)+92)

Just different... :>0
Dana DeLouis