Numbers used for Ranking

L

Lowkey

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.
 
L

Lowkey

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

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
 
J

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)
 
Top