Excel lbs to stones and pounds

  Graham ® 09:42 02 Jul 06
Locked

Doctors orders says I must lose weight (and stop drinking :-( ).

So my chart reads
A) date
B) weight in pounds

I wish
C) Stones and pounds

VoG™, you did this for me before, but that computer is long gone!

  VoG II 09:46 02 Jul 06

=INT(B1/14) & " St " & INT(MOD(B1,14)) & " lb(s)"

  Graham ® 09:54 02 Jul 06

Hmm, step by step please! My first entry in B is B3.

  daba 09:59 02 Jul 06

so in C3 put VoG's formula, but change B1 to B3...

=INT(B3/14) & " St " & INT(MOD(B3,14)) & " lb(s)"

then for every weight in lbs entry (B3 downwards), just copy the formula in C3 down, it will automatically adjust to the new row.

  Graham ® 10:04 02 Jul 06

Ah, Paste Special, text!

Thanks both.

  Cesar 08:16 03 Jul 06

^

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…