You are add the 2% twice. What you need is
=C4*2%+(C415651.89)*(C4-15651.89)*3%
or
=MIN(C4,15651.89)*2%+(C415651.89)*(C4-15651.89)*5%

Odd how the same question popped up twice today
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"George" wrote in message
...
Excel 2007
The amount to this formula should be 363.04
=(C4*2%+(C415651.89)*(C4-15651.89)*5%)
where C4 = 16651.89
I need to find 2% of C4 up to 15651.89 and anything over that (difference)
at 5%