In cell I9, create a formula without using a function that first adds the selected boxed sets net weight (cell I8) to the packing weight (cell E5), and then divides the value by 16 to show the shipping weight in pounds Answer should be 2 9 i need the formula that will equal 2 9 the formula (I8 E5) 16 doesn't work Product Information Lookup Sweet Stuff 363 5 29 Boxed Set Calories of Components Net Weight (oz ) Shipping Weight (Ibs ) Overweight No Product Information Lookup Sweet Stuff 363 5 29 Boxed Set Calories of Components Net Weight (oz ) Shipping Weight (Ibs ) Overweight No

The Answer is in the image, click to view ...

Question: In cell I9, create a formula without using a function that first adds the selected boxed sets net weight (cell I8) to the packing weight

In cell I9, create a formula without using a function that first adds the selected boxed sets net weight (cell I8) to the packing weight (cell E5), and then divides the value by 16 to show the shipping weight in pounds. Answer should be 2.9 i need the formula that will equal 2.9 the formula =(I8+E5)/16 doesn't work.

In cell I9, create a formula without using a function that first

adds the selected boxed sets net weight (cell I8) to the packing

Product Information Lookup Sweet Stuff 363 5 29 Boxed Set Calories # of Components Net Weight (oz.) Shipping Weight (Ibs.) Overweight? No Product Information Lookup Sweet Stuff 363 5 29 Boxed Set Calories # of Components Net Weight (oz.) Shipping Weight (Ibs.) Overweight? No

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 Databases Questions!

In cell I9, create a formula without using a function that first adds the selected boxed sets net weight (cell I8 ) to the packing weight (cell F5 ), and then divides the value by 16 to show the...

In cell I9, create a formula without using a function that first adds the selected boxed sets net weight (cell I8) to the packing weight (cell F5), and then divides the value by 16 to show the...

Final Figure 1: Product Lookup Worksheet H You've Got Style 4/25/2016 10.48 shirt Blouse 160 Pecking Weight (oz.) Bored Set 6 Pants/shorts 252 Item Court 7 Dress/Skirt 96 # of Components S Sweater...

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS GETTING STARTED Open the file NP_EX19_3b_ FirstLastName _1.xlsx , available for download from the SAM website. Save the file as NP_EX19_3b_...

Need a lot of help figuring out this excel assignment please and thank you. Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The...

1 . Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments Division is planning to manufacture and...

Can you do it step by step, thank you 1. Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments...

1. Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The MedSight Auditory Instruments Division is planning to manufacture and...

PROJECT STEPS 1. Felicia Narvaez works for Youve Got Style, a clothing company that sends boxed sets of curated clothing to its subscribers. She keeps track of the companys sales and inventory, as...

41 42 11. In cell 16, create a formula using the VLOOKUP function to display the number of items in the selected clothing set. Use the clothing set listed in cell 15 as the lookup value, the range...

You brought your work home one evening, and your nephew spilled his chocolate milk shake on the variance report you were preparing. Fortunately, you were able to reconstruct the obliterated...

Explain the circumstances under which a single college graduate would or would not need life insurance. What life-cycle events would change this initial evaluation, and how might they affect the...

Problem Set 8 4 Problem E 4 : Accounting for Bad Debts ( 3 0 points ) Page 1 2 of 1 4 Presented below are three independent fact situations related to the accounting and reporting of accounta...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

14-6 It has been said that most systems fail because systems builders ignore MyLab MIS MyLab MIS organizational behavior problems. Why might this be so?

14-2 What methods can be used for selecting and evaluating information systems projects and aligning them with the firms business goals?

14-3 How can firms assess the business value of information systems?