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