LBS OZ formula

[RustyJOliver]

Hi, I have done a lot of searching everywhere and came up with a few different ways of doing this, but the final formula that started working for me needs help. Here is what I need:

I can only export the data i need from a price field ie: 0.00 due to the limitations of the program I use. A lot of the weight i need to calculate is less than 1oz.

So I have entered in the price field 112.3 this comes out to 1lb 12.3oz next line entered at 3.7 (3.7oz) this should come out to 2lbs total but i the formula is producing 2lbz 16oz until i add another oz then the 16oz goes away correctly.

Because I am very rusty with formula's i have only been able to create my weights in A1:A300 then in B1 i have =sum(A1:A300)/100 producing (1.16)
then in C1 i have:

=INT(SUM(INT(B1))+SUM(MOD(B1,1)*100)/16)+MOD(SUM(MOD(B1,1)*100),16)/100

hope this makes sense if not just yell at me.

 

[RustyJOliver]

If your total is 51lbs 95oz I make that 56lbs 15oz

Sorry I missed the 1. its 50lbs 195oz that comes out to 62.1875 the formula is showing 62lbs 3.0oz the first formula is showing 62.1875 but that should be moved to 63lbs 2oz shouldnt it?

=DOLLARFR(SUM(DOLLARDE(A1:A300/100,16)),16)
comes up with 62.03 62lbs 03.0oz why is it converting 1875 to 3.0?

 

[Fluff]

If you take the decimal fraction (ie 0.1875) and multiply it 16 (to convert it to ounces) you get 3oz.
Or to put it another way if you have 195oz & 12lbs=192oz 195-192 =3