kay asked in Computers & InternetSoftware · 1 year ago

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.

Update:

Like how would I write it in excel to get 2.9

2 Answers

Relevance
  • Bill-M
    Lv 7
    1 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.

  • rmm
    Lv 7
    1 year ago

    =(E5+I8)/16

    Results in 3.6875

    Not sure what it needs to get to 2.9?? Different net or packaging weight??

Still have questions? Get answers by asking now.