Need a book? Engineering books recommendations...
Return to index: [Subject] [Thread] [Date] [Author]
RE: feet inch calculator
[Subject Prev][Subject Next][Thread Prev][Thread Next]- To: <seaint(--nospam--at)seaint.org>
- Subject: RE: feet inch calculator
- From: "John P. Riley" <jpriley485(--nospam--at)peoplepc.com>
- Date: Thu, 6 May 2004 15:41:16 -0500
Rajendran,
I added a
"round" function, which makes the fraction look better.
=INT(A2)&CHAR(39)&"-"&INT((A2-INT(A2))*12)&"
"&ROUND(16*((A2-INT(A2))*12-INT((A2-INT(A2))*12)),0)&"/16"&CHAR(34)
The string
above can be cut/pasted, here the additions should show up in
bold-red:
=INT(A2)&CHAR(39)&"-"&INT((A2-INT(A2))*12)&"
"&ROUND(16*((A2-INT(A2))*12-INT((A2-INT(A2))*12)),0)&"/16"&CHAR(34)
Thanks for
sharing this with us.
John
Riley
-------------------
Rand,
You may get an ugly looking fraction depending on the nature of input.
Assuming you want the fraction expressed as a sixteenth, here is a suggestion.
Beware that 0.5" will compute as 8/16 etc. If you want more pleasant looking
conversion, you may require a macro.
=INT(A1)&CHAR(39)&"-"&INT((A1-INT(A1))*12)&"
"&16*((A1-INT(A1))*12-INT((A1-INT(A1))*12))&"/16"&CHAR(34)
Regarding your second question, as far as I know you cannotavoid preceding
an Excel formula with the "=" sign. It is a programming format.
Rajendran
"Rand Holtham, P.E." <rand(--nospam--at)sigmaengineers.com> wrote:
"Rand Holtham, P.E." <rand(--nospam--at)sigmaengineers.com> wrote:
Rajendran,
What would you do to have that formula give you the proper fraction of an
inch?
Also does anyone know if there is a setting so that you don't have to enter
an "=" sign before a formula. In Lotus 123 you don't have to but you have to
precede text with a ' symbol.
Rand
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
- References:
- Re: feet inch calculator
- From: Padmanabhan Rajendran
- Re: feet inch calculator
- Prev by Subject: Re: feet inch calculator
- Next by Subject: finite element analysis free
- Previous by thread: Re: feet inch calculator
- Next by thread: Joints in Slab on Grade
- About this archive
- Messages sorted by: [Subject][Thread][Author][Date]