This works, also. Thanks!!
--
smither fan


"Satti Charvak" wrote:

to help you understand i 'll try:

=IF(A1<=50,A1+A1*10%,A1+(50*10%)+((A1-50)*5%))

or

in shorter form

=IF(A1<=50,A1+A1*10%,A1+5+((A1-50)*5%))

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Ross" wrote:

Please help! I have an amount in cell A1 and I need a formula in B1 that will
give me 10% of the first 50, then 5% of anything over that and sum the total.
If the original amount is $100, I should get an answer of $107.50. Any
ideas??

Thanks
--
smither fan