Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
EXCEL help If cell I8 is 29 and cell E5 is 30 and it says to divide by 16 , how does it come to 2.9????
In cell I9,create a formula without using a function that first adds the selected boxed set’s net weight (cell I8) to the packing weight (cell E5), and then divides the value by 16 to show the shipping weight in pounds.
Like how would I write it in excel to get 2.9
2 Answers
- Bill-MLv 71 year ago
If you first Add Cell I8 (29) and Cell E5 (30) Then you divide that sum by 16 you will get 3.6875.
29+30 = 59
59/16 = 3.6875
Even if you divide 29/16 first and 30/16 second and add the results you still get 3.6875.
With those numbers: 29, 30, and 16, I don't see how you can get 2.9 With what you have told us.
- rmmLv 71 year ago
=(E5+I8)/16
Results in 3.6875
Not sure what it needs to get to 2.9?? Different net or packaging weight??
