Forum Discussion
Kgs to lbs to Stones and pounds (UK)
Hi There,
Just trying to set up a simple spreadsheet to track weight loss.
Simple, but I am struggling with the last part I would like on the sheet, namely, showing the weight in Stones and Pounds. e.g. 15st 12lbs.
I have reached a point where I have converted 101kgs to 222.2 lbs. I have then converted 222.2 lbs to 'decimalised' stones "15.8714286" and, via 'ROUNDINGDOWN' etc. I have managed to separate the decimalised stones into two cells, one with the Stones "15" in and one with ".8714286" in. I have multiplied by 1.4 (10/14) and applied 'ROUND' to get to the nearest pound "12", but I do not know how to combine the two cells into one to show '15 st 12 lbs'.
Can this be done?
Any help gratefully received.
Many thanks
Austin
For such data
formula in B1 could be
=IF(INT(MROUND(A1,0.5)/14),INT(MROUND(A1,0.5)/14) & " st ", "") & MOD(MROUND(A1,0.5),14) & " lbs"assuming in A1 is already the result of conversion.
4 Replies
For such data
formula in B1 could be
=IF(INT(MROUND(A1,0.5)/14),INT(MROUND(A1,0.5)/14) & " st ", "") & MOD(MROUND(A1,0.5),14) & " lbs"assuming in A1 is already the result of conversion.
