Asked by Bryan
Formulas are a great way to save time and effort when using Excel… what are some ideas for formulas you could create to help you with this situation?
* You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Really Need help with this
* You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
Really Need help with this
Answers
Answered by
bobpursley
=IF,(sellingvalue > 1.2 cellcost, then_commission cell=.06*cellcost, otherwise_commissioncell=0)
Put this in the commissioncell would change it to..
=IF,(sellingvalue > 1.2 cellcost, then_.06*cellcost, otherwise_0)
Put this in the commissioncell would change it to..
=IF,(sellingvalue > 1.2 cellcost, then_.06*cellcost, otherwise_0)
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.