View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bapeltzer bapeltzer is offline
external usenet poster
 
Posts: 43
Default 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%