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.
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.
