R
Roy Gudgeon
Hi guys
KNow you guys can help with this...
I need a formula that will calculate lbs & oz when data is entered:
49.02
35.15
24.13
this needs to take account that 1lb = 16 oz, using decimals it would assume
this once 10 is reached.
I dont want to have the lbs and oz in seperate cells if possible
adding my numbers up manually comes out at 109.14
Hope this makes sense.
KNow you guys can help with this...
I need a formula that will calculate lbs & oz when data is entered:
49.02
35.15
24.13
this needs to take account that 1lb = 16 oz, using decimals it would assume
this once 10 is reached.
I dont want to have the lbs and oz in seperate cells if possible
adding my numbers up manually comes out at 109.14
Hope this makes sense.