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

One way:

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


In article ,
ebank23 wrote:

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

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

"JE McGimpsey" wrote:

One way:

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


In article ,
ebank23 wrote:

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

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


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

"JE McGimpsey" wrote:

One way:

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


In article ,
ebank23 wrote:

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

The easiest is probably a nested if statement:

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

Hope that works!

"ebank23" wrote in message
...
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!!