Mick
I haven't seen one reply that directly answered your question. Here is what
you want to type into your cell. A3 would be your cell with the 12.5
=INT(A3)*14+(A3-INT(A3))*10
Brian
-----Original Message-----
From: PCSOFT - Personal Computer software discussion list
[mailto:[log in to unmask]] On Behalf Of Mick Fitzpatrick
Sent: Tuesday, September 27, 2005 6:51 AM
To: [log in to unmask]
Subject: Re: [PCSOFT] Excel formula to convert stones to pounds
Thanks for the reply Peter.
I understood you up to the =INT(A5) ... then I don't understand.
Imagine I have entered the weight like this in A5 12.5 (meaning 12 stones
and 5 pounds). There is 14 lbs in a stone.
What I'd like to appear in B5 is 173
I've read a couple of replies but I don't understand what they mean. What
would make it easier for me to understand is what formula I type 'exactly'
into B5 to make this conversion.
TIA ... Mick
This is easy. You need to separate the whole number from the fraction. Excel
has the function INT that will extract the whole number part. Thus, if you
have 12.7 in cell A5, then in cell B5 you could enter =INT(A5) and you will
see only the whole number 12. To get the fraction, just subtract the whole
number form the original and you will have 0.7 in this case. Converting the
fraction to a whole number, however, depends on how you enter the pounds
portion if it is greater than 9. How do you differentiate between 1 pound
and 10 pounds?
Hope this helps you get going.
Peter
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://freepctech.com/pcsoft.shtml
|