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)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. statistics

    a training manager wants to know if there is a link between the hours spent by particular category of employeee in training and their productivity on the job. a ssmple of 10 employee files was randomly selected and the following data …
  2. Data Analysis

    You are a District sales manager and you are overloaded with data that you need to compile into useable data and you are looking to use Excel to help you do this. Using the concept from this week, how will you determine where to start …
  3. Computers/Excel

    You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  4. Computers

    How to do Excel Spreadsheet- Formulas? I have to do an excel spreadsheet for my computer class. Problem is my professor didn't at all explain how to do it. What formulas am I supposed to use! Please Help. The info he gave us are :
  5. computers

    You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  6. Microsoft Excel

    The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
  7. computer applications

    John wants to see the formulas he has used in his spreadsheet but he does not want to see the results of the formulas. How does he display his formulas?
  8. Intro to computers

    You are an inexperienced Excel user and don’t know how to create your own formulas. You want to use one of the preconfigured formulas but it doesn’t appear in the Formulas tab ribbon. What can you do?
  9. Data Analysis with spreadsheets with Lab

    Using the IF function calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost.
  10. Math- Formulas

    What are some formulas that you use in everyday life and how do you use them?

More Similar Questions