1. Math
  2. Statistics And Probability
  3. 4 find the following a b...

Question: 4 find the following a b...

Question details

4. Find the following:

a.

The unit price varies depending on the specified quantity, and your goal is to write a formula in cell B9 that calculates the total price for any amount of items input in a specific cell (in this case, cell B8) 1 Unit Quantity 2 1 to 10 3 11 to 19 4 20 to 49 5 50 to 100 6 Over 100 7 8 Quantity 9 Total Cost Price Per Unit 20.00 28.00 16.00 13.00 12.00 Write a nested IF function based on the above criteria to display the total cost of an order in cell B9 for any given ordered quantity B8 IF(B8>-101, 12, IF(B8 50, 13, IF(B8>-20, 16, IF( B8> 11, 18, IF(B8> 1, 20, ))) OB8 IF(B8>101, 12, IF(B8<50, 13, IF(B8<20, 16, IF( B8<11, 18, IF(B8>1, 20, ) B8 IF(B8-100, 12, IF(B8 50, 13, IF(B8-20, 16, IF B811, 18, IF(B8>-1, 20, ) -B8 IF(B8 100, 12, IF(B8>50, 13, IF(B8>20, 16, IF( B8 11, 18, IF(B8>1, 20, )

b.

For a particular month, the worksheet below shows the inventory of cel phones in stock at the beginning of the month. It also shows the number of cell phones of each type that have been sold during the month. When there are less than 10 phones in the inventory, it is time to replenish the stock. Write a statement for cell D2 to be copied for column D that will display the text, Order if more cell phones need to be ordered, yet leave the cell blank if more cell phones do not need to be ordered 1Smartphone Model 2 Nokia 6500 Classic 3 Samsung SGH-E250 4 LG Shine Quantity in Stock Quantity Sold Order More? 51 52 60 45 37 Apple Iphone 6 LG Viewty HTC Touch 8 Palm Centro 72 51 30 46 Order IF((C2-B2)<= 10, Order) IF(B2-C2)<10, Order, ) -IFIABS(B2-C2) 10,Order, ) IFIABS(B2-C2)<10,Order, )

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution