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]
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