Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please, can you help creating a formula in Excel using IF Statement (column H) and another formula using Nested IF statement (Column E). Assume that
Please, can you help creating a formula in Excel using IF Statement (column H) and another formula using Nested IF statement (Column E). Assume that we have the following profit margins: desktop CPU (or laptop) profit margin is 25%, 101 keyboard profit margin is 10%, 17'' monitor is 10%, pc mouse is 5%. How much profit did we make this quarter? What is our total profit margin?
store number | sales region | item number | item description | unit price | units sold | month-year | Sale Amount |
1 | South | 6150 | PC Mouse | $53.00 | 30 | 16-Jan | $1,590.00 |
1 | South | 3006 | 101 Keyboard | $138.00 | 30 | 16-Jan | $4,140.00 |
1 | South | 2015 | 17" Monitor | $563.00 | 31 | 16-Jan | $17,453.00 |
1 | South | 8500 | Desktop CPU | $1,283.00 | 30 | 16-Jan | $38,490.00 |
1 | South | 6150 | PC Mouse | $58.00 | 7 | 16-Feb | $406.00 |
1 | South | 3006 | 101 Keyboard | $150.00 | 37 | 16-Feb | $5,550.00 |
1 | South | 2015 | 17" Monitor | $547.00 | 30 | 16-Feb | $16,410.00 |
1 | South | 8500 | Desktop CPU | $1,312.00 | 31 | 16-Feb | $40,672.00 |
1 | South | 6150 | PC Mouse | $43.00 | 38 | 16-Mar | $1,634.00 |
1 | South | 3006 | 101 Keyboard | $113.00 | 40 | 16-Mar | $4,520.00 |
1 | South | 2015 | 17" Monitor | $546.00 | 14 | 16-Mar | $7,644.00 |
1 | South | 8500 | Desktop CPU | $1,298.00 | 35 | 16-Mar | $45,430.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started