Need a book? Engineering books recommendations...

# RE: feet inch calculator

• 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:
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