I will assume that you have Cost numbers in column A, Sales numbers in column B.
Try this formula in cell C1:
=if(B1>=1.2*A1, 0.06*B1,"")
Using the IF function calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
1 answer