I do have a follow up question:

If you want to apply the above function to categories, for instance:

95-100%
60-95%
30-60%
10-30%
0-10%

How do you write these functions?


regards
Christian


--
chlor
------------------------------------------------------------------------
chlor's Profile: http://www.excelforum.com/member.php...o&userid=31576
View this thread: http://www.excelforum.com/showthread...hreadid=512715