View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default Add to commision formula

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