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...
11 Above were high-grade stones, cut to size, and cedar beams. Read full chapter 1 Kings 7:11 New King James Version 11 And above were costly stones, hewn to size, and cedar wood. Read full chapter 1 Kings 7:11 King James Version 11 And above were costly stones, after the...
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 ...
11And abovewerecostly stones, hewn to size, and cedar wood. Read full chapter 1 Kings 7:11 King James Version 11And above were costly stones, after the measures of hewed stones, and cedars. Read full chapter New International Version(NIV) ...
=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 Assuming your columns are Column A = Stones and B = Pounds. ...
{\"entities\":[\"board:ExcelGeneral\",\"message:1331520\"],\"name\":\"ForumReplyPage\",\"props\":{},\"url\":\"https://techcommunity.microsoft.com/discussions/excelgeneral/kgs-to-lbs-to-stones-and-pounds-uk/1331520/replies/1331551\"}}})":{"__typename":"ComponentRenderResult","...
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....
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....
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....
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....