Forum Discussion
Solved
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 Poun...
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.
Two additional points, if I may: 1) how do you ROUND to the nearest half a pound? So, e.g. 13.6 lbs rounded to 13.5 rather than 14, and 2) how do you get the cell to recognise 14lbs as one stone? Thanks.
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.