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.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5