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