How do I convert ounces to pounds

Mar 7th, 2002, 08:17 AM

I am starting with 10 ounces and adding .6 to the following cells. So it starts with 10, next cell is 10.6, next is 11.2 etc. When it gets to 16 ounces I would like to start reading 1 lb 0 ozs, 1 lb 0.6 ozs, etc.
Someone on a message board (don't know if it was this one) gave me the answer about 6 months ago and it worked great. I had my hard drive crash and lost the document (no backup) and am trying to recreate the file.
Any help would be greatly appreciated.
Thanks,
Tracy

Steve Hartman · Mar 7th, 2002, 08:59 AM

=INT(A1/16)&" lbs "&ROUND(MOD(A1,16),1)&" ozs"

Will do it

Mar 7th, 2002, 09:10 AM

Thanks, that was it. I won't lose it this time. I appreciate your quick response.

Mar 7th, 2002, 08:59 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	=INT(A1/16)&" lbs "&ROUND(MOD(A1,16),1)&" ozs" Will do it __________________ Veni, Vidi, Velcro - I came, I saw, I stuck around Taxation WITH representation ain't so hot either

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 08:17 AM	#1
Guest Posts: n/a	I am starting with 10 ounces and adding .6 to the following cells. So it starts with 10, next cell is 10.6, next is 11.2 etc. When it gets to 16 ounces I would like to start reading 1 lb 0 ozs, 1 lb 0.6 ozs, etc. Someone on a message board (don't know if it was this one) gave me the answer about 6 months ago and it worked great. I had my hard drive crash and lost the document (no backup) and am trying to recreate the file. Any help would be greatly appreciated. Thanks, Tracy

Mar 7th, 2002, 09:10 AM	#3
Guest Posts: n/a	Thanks, that was it. I won't lose it this time. I appreciate your quick response.