Why not just this instead?
=TRUNC(A1/0.3048)&" feet "&ROUND(MOD(ABS(A1)/0.3048,1)*12,0)&" inches"
Rick
"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Checking again in the negative number case, it does need something a
bit more complicated, such as:
=TRUNC(A1/0.3048)&" feet
"&ABS(ROUND((A1/0.3048-TRUNC(A1/0.3048))*12,0))&" inches"
--
David Biddulph
"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Better to divide by 0.3048, rather than to multiply by what isn't
exactly the reciprocal.
Also, why are you using the strange ROUND construct, rather than
using TRUNC (or INT if the number is positive, as your ROUND only
works for positive numbers)?
Isn't =TRUNC(A1/0.3048)&" feet "&ROUND(MOD(A1/0.3048,1)*12,0)&"
inches" a bit easier than
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches" ?
--
David Biddulph
=ROUND(A1*3.2808399-0.5,0)&" feet
"&ROUND((A1*3.2808399-ROUND(A1*3.2808399-0.5,0))*12,0)&" inches"
Here I'm converting the value in A1 from meters to feet using
3.2808399 feet
per meter. The first part truncates the decimal protion and adds,
"feet" and
the second part truncates the integer portion and convert it to
inches and
adds "inches"
:
i'm trying to convert from meters to feet and inches (not just
feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches
for
example not 6.x feet or 78 inches.
here's the formula i have, which i can't get right.
=CONVERT(2,"m","ft""in").
tia