Forum Discussion

AustinM64's avatar
AustinM64
Copper Contributor
Apr 23, 2020
Solved

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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 23, 2020

    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.

     

Gaffers's avatar
Gaffers
Copper Contributor
Apr 23, 2020

AustinM64 

 

Assuming your columns are Column A = Stones and B = Pounds.

A2 = 15

B2 = 12

 

Put the formula in column C.  =A2&"st "&B2&"lbs."

Result = 15st 12lbs

Resources