View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Add to commision formula

"George" wrote:
Excel 2007
I have the folowing formula:
=MIN(B4,15651.89)*2%+(B415651.89)*(B4-15651.89)*5%
Now I need to add cell C4, if C4 is below 15651.89 then D4
should equal 2% of C4, if C4 is above 1561.89 then D4 should
equal 2% of 15651.89 plus 5% of anything over 15651.89


How many times do you intend to post essentially the same question?

See responses to your later posting titled "Wrong amount formula".