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 reache...
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...
Re: 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. ...