Asked by Anonymous

Using the IF function calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Answered by Answering Life's Questions
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,"")