I have a list of choices for a Ranking to calculate bonus pay
1,2,3, and 4 where
1=0%
2=50%
3=100%
4=150%
I need a function that shows the %, depending on the ranking. Kind of an
IF/Then thing, but I can't get it to work.

One way:

A1: <1, 2, 3 or 4

B1: =(A1-1)*50%

In article ,
Lowkey wrote:

I have a list of choices for a Ranking to calculate bonus pay
1,2,3, and 4 where
1=0%
2=50%
3=100%
4=150%
I need a function that shows the %, depending on the ranking. Kind of an
IF/Then thing, but I can't get it to work.

That solution would work, but I need the variability in case the payout
multiplier changes. Eg.
1=0%
2=55%
3=100%
4=175%

"JE McGimpsey" wrote:

One way:

A1: <1, 2, 3 or 4

B1: =(A1-1)*50%

In article ,
Lowkey wrote:

I have a list of choices for a Ranking to calculate bonus pay
1,2,3, and 4 where
1=0%
2=50%
3=100%
4=150%
I need a function that shows the %, depending on the ranking. Kind of an
IF/Then thing, but I can't get it to work.

=IF(A1=1,"0%",IF(A1=2,"50%",IF(A1=3,"100%",IF(A1=4 ,"150%","invalid rank"))))

if you want to do the calculation at the same time
you could enter
=IF(A1=1,B1,IF(A1=2,1.5*B1,IF(A1=3,2*B1,IF(A1=4,2. 5*B1,"invalid rank"))))

with B1 containing the standard rate or value

--
Greetings from New Zealand
Bill K
"Lowkey" wrote in message
...
I have a list of choices for a Ranking to calculate bonus pay
1,2,3, and 4 where
1=0%
2=50%
3=100%
4=150%
I need a function that shows the %, depending on the ranking. Kind of an
IF/Then thing, but I can't get it to work.

Always helps to give a complete specification first, of course. Use a
lookup table:

J K
1 1 0%
2 2 55%
3 3 100%
4 4 175%


Then

=VLOOKUP(A1,J:K,2, FALSE)



In article ,
Lowkey wrote:

That solution would work, but I need the variability in case the payout
multiplier changes. Eg.
1=0%
2=55%
3=100%
4=175%