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.