Question

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

Answer 1

=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)