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
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,"")
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!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.