I have a s/sheet set up where I want to average percentages.

I have 3 columns

1 where actual percentages are entered
2 where a number (1-5) is entered - no other numbers should be allowed
3 the total column that works out the overall percentage


I can do parts 1 and 3 not a problem.

I'm struggling with part 2 in terms of getting those numbers, 1-5 to be
converted to percentages that I want.

I need :-

1 to equal 0%
2 = 25%
3 = 50%
4 = 75%
5 = 100%

How do I do that and additionally, how do I ensure that the user can
ONLY input 1-5 in that particular column.

Once I can get the percentages for column 2, I can then average that
and column 1 into column 3.

Any help would be most welcome.

Thanks.


--
koit
------------------------------------------------------------------------
koit's Profile: http://www.excelforum.com/member.php...o&userid=31100
View this thread: http://www.excelforum.com/showthread...hreadid=507665