Homework Help: Data Analysis

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

Excel - Want to create a worksheet that will help track your grades and. What ...
Chemistry - WHat are the structural formulas for glycerin, hexane, and ethanol. ...
Data Analysis - You are a District sales manager and you are overloaded with ...
Data Analysis Excel - Why would you exchange information between Excel and some ...
Excel & Math - I'm not sure what two excel functions to use that will ...
Math/Excel - I'm not sure what two excel functions to use that will give the...
Business - Research the Goldman Sachs website. Using your research findings from...
BIS 155 Data Analysis w/Spreadsheet - How would I begin to compile data into ...
Math - When something says that I'll be tested on formulas for perimeter and...
Physics - A track star in the long jump goes into the jump at 12 m/s and ...

For Further Reading

First Name:
School Subject:
Answer: