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

 

[etaf]

can you be more specific ....

However, assuming that you want to put the Value 1 to 5 in a cell wher
another cell is grouped as percentages

try (I have assumed the cell is formated as %, hence decimal values)
=IF(D9=1,5,IF(D9>=0.75,4,IF(D9>=0.5,3,IF(D9>=0.25,2,1)))

 

[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