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.