Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel formula to convert stones to pounds
From:	Mick Fitzpatrick <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Tue, 27 Sep 2005 11:50:30 +0100
Content-Type:	text/plain
Parts/Attachments:	text/plain (33 lines)

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

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG