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......
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...
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. ...
=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. AustinM64 For such data formula in B1 could be =IF(INT(MROUND(A1,0.5)/14),INT(MROUND(A1,0.5)/14) & " st ", ""...
Kgs to lbs to Stones and pounds (UK) AustinM64 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....
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you the services will be used. You may cha...