Question: On the SalesData worksheet, in cell G 4 , create a formula that will 4 . 8 perform a calculation that multiplies the Unit Price

On the SalesData worksheet, in cell G4, create a formula that will 4.8perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue.If the project has sold units, display the results of the Unit Price multiplied bythe sum of the products sold for January, February, and March. Copy the formula, and then paste it in cells G5, G7:G9, G11:G12, G14:G15, and G17:G18. Resize the column as needed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!