Numbers used for Ranking

[Guest]

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.

 

[JE McGimpsey]

One way:

A1: <1, 2, 3 or 4>

B1: =(A1-1)*50%

 

[Guest]

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

 

[Bill Kuunders]

=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

 

[JE McGimpsey]

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)