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

"Rand Holtham, P.E." <rand(--nospam--at)> wrote:

What would you do to have that formula give you the proper fraction of an

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.


Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs