Question
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
3.42 Rating (165 Votes )
There are 3 Steps involved in it
Step: 1
puolit Mangin desktop CPU 101 keyboard 17 Monitor PC Mouse pol Key 17 Monitor PC Mouse Profit Ma...
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
Vector Mechanics for Engineers Statics and Dynamics
Authors: Ferdinand Beer, E. Russell Johnston, Jr., Elliot Eisenberg, William Clausen, David Mazurek, Phillip Cornwell
8th Edition
73212229, 978-0073212227
