Excel lbs to stones and pounds

  Graham ® 09:42 02 Jul 2006
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 2006

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

  Graham ® 09:54 02 Jul 2006

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

  daba 09:59 02 Jul 2006

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 2006

Ah, Paste Special, text!

Thanks both.

  Cesar 08:16 03 Jul 2006

^

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Les meilleures tablettes 2017