How do I? (Excel help)

[Robmarriott]

I have a spreadsheet which I add my weight to week on week to track my weight loss progress.

I'm inputting the data in kg but want it to show in stone and lb too.

So what formula do I need to convert it from "xxx.x kg" to "xx st x.xx lb"

Using "sum=(cell*2.204)/14" (cell for cell number, obviously, not the word cell) I can get it to do it as a number to 2 decimal places but it does the following;

100 (kg) ---> 15.74 (st)

I want it to take that .74 stone and do it as lb to 2dp

Anyone know how? I've been entering it manually but it's a bit boring doing it that way.

[nyt]

https://www.extendoffice.com/documents/excel/5283-...

[toasty]

B1=A1*2.204/14

Stones C1=ROUNDDOWN(B1,0)

Pounds D1=ROUND(((B1-C1)*14),2)

Edited by toasty on Monday 29th April 09:34

[Alex]

Stone
=QUOTIENT(A1*2.204,14)

Pounds
=MOD(A1*2.204,14)

[Robmarriott]

Perfect, thanks guys

[Alex]

In one cell you could do:

=QUOTIENT(A1*2.204,14)&" st "&MOD(A1*2.204,14)&" lbs"

If A1=100 this would give:

15 st 10.4 lbs