=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. ...
40 kilograms is equivalent to approximately 88.18 pounds. How much is 40 kg in weight? 40kgs equates to 88.1 (88.1849) pounds. How much will 40kgs be in stones? 40 kilograms is approximately 6.3 stones. To convert kilograms to stones, you can divide the weight in kilograms by 6.35. How...
=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 ", ""...
I have reached a point where I have converted 101kgs to 222.2 lbs. I have then converted 222.2 lbs to 'decimalised' stones "15.8714286" and, via 'ROUNDINGDOWN' etc. I have managed to separate the decimalised stones into two cells, one with the Stones "15" in and one with ...
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....
I have reached a point where I have converted 101kgs to 222.2 lbs. I have then converted 222.2 lbs to 'decimalised' stones "15.8714286" and, via 'ROUNDINGDOWN' etc. I have managed to separate the decimalised stones into two cells, one with the Stones "15" in and one with "....
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...