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".
|