View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roy Gudgeon[_2_] Roy Gudgeon[_2_] is offline
external usenet poster
 
Posts: 36
Default adding lbs & oz's

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