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. View solution in original p...
Really easy to use, no complicated buttons/instructions. One screen and shows you lbs to stones perfectly 👏🏽 alot less hassle than trying to google it especially when your in a hurry! Helps so much because mostly all scales are lbs or kgs which is a pain! I want to know in stones...
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. View solution in ...
e.g. 15st 12lbs. 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 "1...