Post a New Question

Data Analysis

posted by .

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

  • Data Analysis -

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

Answer This Question

First Name:
School Subject:

Related Questions

More Related Questions

Post a New Question