With sales in A1:A10, enter this formula in B1, and copy down to get the
commissions for each sales value:

=IF(RANK(A1,$A$1:$A$10)3,A1*0.0025,A1*CHOOSE(RANK (A1,$A$1:$A$10),0.02,0.01,
0.005))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dug" wrote in message
...
I have a Excel spread sheet of emplyees sales. For this example lets say
that
cells A1 to A10 have emplyoee sales for the month. I need to calculate
their
commissions but the commissions are based on the emplyee sales ranking.
The
top seller gets 2% 2nd place gets 1% 3rd place gets 0.5% and the rest get
.25%. How can I have Excel calculate the biggest number then the 2nd
biggest
then the 3rd biggest etc... Thank you!!