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