Question Locked

How do I create value limits in Excel?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Customer wants to create a formula for commission. Possible commission is calculated as 20% (=C8*20%) of total sale. Actual commission is 50%(=1/2*J25) of profit. If over possible commission cell should reflect only possible commission, if under possible commission cell should reflect exact amount.
I don't have very much experience with Excel and your help would be greatly appreciated.

2 replies

by fjcs1963

Your formula can be =MIN((C8*.2),(J25*.5)). This will return whichever value is lower.

Regards,

Ferdie

This discussion is closed to new replies.