use an if statement. for example
=IF(A2=1,100%,IF(A2=2,80%,IF(A2=3,60%,IF(A2=4,40%, 20%))))

"AL" wrote:

I am trying to calculate a percentage based on a ranking system. For
example, #1 is the best. My problem:

1 out of 5 calculates to a percentage of 20%. I would like it to be a 100%
since 1 is the best.

Any help??