posted by Bryan on .
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
=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)