Digital Spy

Search Digital Spy
 

DS Forums

 
 

Excel: Stone to Kilograms Formula - help!


Reply
Thread Tools Search this Thread
Old 10-06-2008, 09:17
cpdave
Forum Member
 
Join Date: Jan 2006
Location: Aberdeenshire
Posts: 32

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
cpdave is offline   Reply With Quote
Please sign in or register to remove this advertisement.
Old 10-06-2008, 09:29
media guy
Forum Member
 
Join Date: Oct 2002
Location: Southampton (Uni, Staff)
Posts: 3,799
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"
media guy is offline   Reply With Quote
Old 10-06-2008, 09:45
cpdave
Forum Member
 
Join Date: Jan 2006
Location: Aberdeenshire
Posts: 32
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
cpdave is offline   Reply With Quote
Old 10-06-2008, 10:14
flagpole
Inactive Member
 
Join Date: Jan 2003
Posts: 43,524
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?????
flagpole is offline   Reply With Quote
Old 10-06-2008, 17:37
pi r squared
Forum Member
 
Join Date: Apr 2003
Posts: 4,088
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!
pi r squared is online now   Reply With Quote
 
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search

 
Forum Jump


All times are GMT +1. The time now is 09:01.