Re: convert meters to feet/inches

Change ROUND to TRUNC.

TheBlueShadow wrote:
I'm trying to put together a chart for track and field. This formula works great except for one thing ... I'm wondering if you can find a solution.

If a pole vault bar is raised to 3.2 meters it equals 10' 6" like your formula produces. But if the bar is raised to 3.35 meters the formula produces 10' 12" ... is there a way to have the formula produce 11' instead?

Thank you. :)

"Rick Rothstein (MVP - VB)" wrote:

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 news:dPmdnRoxotAll9rVRVnyugA@xxxxxxxxx
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 news:JPydnXQjHsFhlNrVnZ2dneKdnZydnZ2d@xxxxxxxxx
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

"sb1920alk" <none@xxxxxxxxxxx> wrote in message news:37CEE131-5FDA-4672-8E84-EA63B18A93FC@xxxxxxxxxxxxxxxx
=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"

"Ann" wrote:

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



.

Relevant Pages

  • Re: 300 ohm folded dipole from ARRL Handbook, early 1990s
    ... The length of the stub makes no sense to me at all, ... For six meters, it matches his dimensions with a center frequency of 50.1 mHz: ... total length 9 feet 3 inches or 2.844 meters. ... shorted length length 8 feet 10 inches or 2.396 meters. ...
    (rec.radio.amateur.antenna)
  • Re: Conversion component Meter/Feet-Inch
    ... However, the problem remains simple and does not need a full component, especially as only you know whether or not you want to round up, round off, or truncate the result and whether you want to consider fractions of an inch or have a specific number of decimal places of accuracy. ... To convert from feet and inches to metres, simply multiply the number of feet by 12, add the number of inches, and divide the result by 39.37. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: convert meters to feet/inches
    ... Here I'm converting the value in A1 from meters to feet using 3.2808399 ... The first part truncates the decimal protion and adds, ... the second part truncates the integer portion and convert it to inches ...
    (microsoft.public.excel.worksheet.functions)
  • Re: convert meters to feet/inches
    ... feet 11 inches. ... If a pole vault bar is raised to 3.2 meters it equals 10' 6" like your formula produces. ... The first part truncates the decimal protion and adds, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: convert meters to feet/inches
    ... Also, why are you using the strange ROUND construct, rather than using TRUNC ... Here I'm converting the value in A1 from meters to feet using 3.2808399 ... adds "inches" ...
    (microsoft.public.excel.worksheet.functions)