Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Markets And The Firm

Authors: Piet Sercu, Raman Uppal

1st Edition

1861523548, 978-1861523549

More Books

Students also viewed these Finance questions