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.

Answers

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,"")
There are no AI answers yet. The ability to request AI answers is coming soon!

Related Questions