Question

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, )

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

=B8*if(B8>=101,12,if(B8>=50,13,if(B8>=20,16,if(B8>=11,18,if(B8>=1,20,"")))))

b)

if(abs(B2-C2)<10,"order"," ")

Add a comment
Know the answer?
Add Answer to:
4. Find the following: a. b. The unit price varies depending on the specified quantity, and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT