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

=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

On Mon, 23 Nov 2009 01:16:01 -0800, GENO
wrote:

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