Use the SMALL function

=SMALL(A1:A10,2)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"aw49" wrote in message
...
I have 3 amounts and I need to calculate a discount on the 2nd and 3rd
lowest
fees. They may all be the same amount or they may be different. There
may
only be 1 amount in which case there is no discount. Any suggestions?