Posted by Bryan on Wednesday, July 15, 2009 at 9:31pm.
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  bobpursley, Wednesday, July 15, 2009 at 9:45pm
=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
Related Questions
 Intro to computers  You are an inexperienced Excel user and don’t know how to ...
 Computers/Excel  You wish to calculate the commission on sales. The commission ...
 Data Analysis with spreadsheets with Lab  Using the IF function calculate the ...
 Computers  How to do Excel Spreadsheet Formulas? I have to do an excel ...
 Microsoft Excel  The order of precedence is very important when building ...
 Data Analysis  You are a District sales manager and you are overloaded with ...
 computer applications  John wants to see the formulas he has used in his ...
 computers  You wish to calculate the commission on sales. The commission is 6% ...
 statistics  a training manager wants to know if there is a link between the ...
 Excel & Math  I'm not sure what two excel functions to use that will give the ...
More Related Questions