Percentages

[GENO]

Hi

I would like to use a scoring method in percentages which would recognise 1
to 5 as 0% - 100%. e.g 1= 0-24%, 2= 25-49%, 3= 50-74%, 4= 75-99% and 5= 100%,
thanking you in advance,

Geno...

 

[Gord Dibben]

=LOOKUP(B1,{1,2,3,4,5},{0.24,0.49,0.74,99,1})*A1 entered in C1

Where A1 contains value, B1 contains 1 through 5


Gord Dibben MS Excel MVP