Hi, could somebody please tell me a formula that would convert grams to lbs,ozs and drams. I know that grams to drams is *0.564383391193 then divide by 256 to lbs but don't know now how to deal with the non full numbers would be grateful for any help cheers
The Monk,
Welcome to the Excel Forum.
Lots of examples if you search the web for "excel formula Convert Grams Pounds".
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Yeah thanks Stanley, have come across those but I want a break down from grams to Pounds, Ounces and Drams not straight from one unit (grms) to another (Pounds) for example. Ideally I would like to know how to automatically split the remaining non whole number from one cell to another, don't know if i'm explaining this very well thanks for your patience.
Hi, could somebody please tell me a formula that would convert grams to lbs,ozs and drams. I know that grams to drams is *0.564383391193 then divide by 256 to lbs but don't know now how to deal with the non full numbers would be grateful for any help cheers
Is A1 contains a mass in grams, then
=A1/453.5923097 converts to lbm
=A1/28.34951936 converts to ozm
=A1/1.77184496 converts to drams
Entia non sunt multiplicanda sine necessitate
Threads merged. Monk, please take a few minutes to read the forum rules.
Maybe this is what you want:
-A-- --B--- -------------------C------------------- 1 gram 1,000 B1: Input 2 lbm 2 B2: =INT($B1/453.592309748811) 3 oz 3 B3: =MOD(INT($B1/28.3495193593007), 16) 4 dram 0.38 B4: =MOD(B1/1.77184495995629, 2)
Hi thanks for your help that was almost exactly what I wanted only one slight problem I have changed the last 2 in B4 to 16 and would like the dram figure rounded to 2 decimal points please once again thanks for your help.
Cheers Paul
just stick it in round()
=ROUND(MOD(B1/1.77184495995629, 16),2)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank You for your help Problem Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks