[cpdave]

Hi - is there anyone who can help me with an excel formula that will convert Stone/Pounds to Kilograms and Kilograms to Stone/Pounds?

I'm trying to set up a spreadsheet to track my diet (impending wedding... )

I've looked at the "=convert" function, but it doesn't do what I'm after...

TIA.

- CPDave

[media guy]

You'll need a column for stones (A1) and one for pounds (A2)

=((A1*14)*0.4536)+(A2*0.4536)

Other way around is taken from http://help.wugnet.com/office/kg-sto...ct1052299.html

=INT(A3*0.157473044418)&" Stones "&ROUND((A3*0.157473044418-INT(A3*0.157473044418))*14,0)&"lbs"

[cpdave]

Originally Posted by media guy

You'll need a column for stones (A1) and one for pounds (A2)

=((A1*14)*0.4536)+(A2*0.4536)

Other way around is taken from http://help.wugnet.com/office/kg-sto...ct1052299.html

=INT(A3*0.157473044418)&" Stones "&ROUND((A3*0.157473044418-INT(A3*0.157473044418))*14,0)&"lbs"

Thank you very much - just what I was after

- CPDave

[flagpole]

Originally Posted by media guy

You'll need a column for stones (A1) and one for pounds (A2)

=((A1*14)*0.4536)+(A2*0.4536)

Other way around is taken from http://help.wugnet.com/office/kg-sto...ct1052299.html

=INT(A3*0.157473044418)&" Stones "&ROUND((A3*0.157473044418-INT(A3*0.157473044418))*14,0)&"lbs"

surely:

=(A1*14+A2)*0.4536 is neater?????

[pi r squared]

Yes that is much neater, not to mention that the nested brackets in the original formula are completely redundant. But at the end of the day, it's a couple of extra CPU cycles that probably amount to about five millionths of a second - you'll probably need quite a few cups of coffee before you notice the speed difference!