Question
June 21, 2007 at 09:26 AM
rblack

How do I create value limits in Excel?

by rblack . Updated 18 years, 12 months ago

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.

This discussion is locked

All Comments