adding lbs & oz's
This array* formula does it, Roy:
=SUM(INT(A1:A3))
+INT(SUM(MOD(A1:A3,1))*100/16)+MOD(SUM(MOD(A1:A3,1))*100,16)/100
assuming your numbers are in A1 to A3, so adjust the range to suit.
*An array formula has to be committed using Ctrl-Shift-Enter (CSE)
instead of the usual <Enter. If you do this correctly then Excel will
wrap curly braces { } around the formula when viewed in the formula
bar - do not type these yourself. If you subsequently edit/amend the
formula you need to use CSE again.
Hope this helps.
Pete
On Aug 4, 5:11*pm, Roy Gudgeon
wrote:
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.
--
thanks
Roy
|