Data Analysis
posted 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

=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
Similar Questions

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 … 
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 … 
Computers/Excel
You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. 
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 : 
computers
You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. 
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? 
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? 
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? 
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. 
Math Formulas
What are some formulas that you use in everyday life and how do you use them?