This just uses 1 Min function:

=MIN(12000+0.02*A1,2000+0.04*A1,0.06*A1)

HTH
--
Dana DeLouis
Win XP & Office 2003


"Wutnik" wrote in message
...
I am trying to create an excel formula for the following scenario:

If the subtotal (ie E74) is 100,000 or less = 6% of E74. If the subtotal
is over 100,000, 6% on the first 100,000, 4% on the next 400,000 and 2%
above
500,000.

Can anyone help? This is a bit out of my league.

Thanks!