converting grams to pounds and ounces

[thomasm61]

I had no trouble converting pounds and ounces to grams, but it's driving me crazy trying to figure out how to reverse the calculation by grams, so that pounds appear in one cell and ounces in another.

I know I need one calculation/cell for the pounds and another for the ounces, but I'm not sure where to go from there.

 

[hollandrob81]

great answer is there any way to add stone aswell? cheers

 

[barry houdini]

Can you give an example - you have a figure in grammes (?) and you want to convert to Stones, pounds and ounces? In a single cell or in three separate cells?

 

[hollandrob81]

yeh, i have my babies weight in grammes in one cell, and i want to have 3 cells with stn, lb and oz in them. i allready have the lbs and oz sorted,

 

[barry houdini]

There are many ways you could achieve that. Assuming you have grammes in A2 then try this formula for stones

=INT(ROUND(A2/28.34952,0)/14/16)

then for pounds

=INT(MOD(ROUND(A2/28.34952,0),14*16)/16)

....and ounces

=MOD(ROUND(A2/28.34952,0),16)

That will give you a result to the nearest ounce