Add to commision formula

[George]

Excel 2007
I have the folowing formula:
=MIN(B4,15651.89)*2%+(B4>15651.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

 

[joeu2004]

Excel 2007
I have the folowing formula:
=MIN(B4,15651.89)*2%+(B4>15651.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".