Wrong amount formula
Your formula is picking up 2% of everthing plus another 5% of the excess;
thus the excess contributes a total of 7%. I think you want
=(C4*2%+(C415651.89)*(C4-15651.89)*3%)
"George" wrote:
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%
|