MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re: Converting decimal feet to feet and inches


Posted by Jim Rich on January 24, 2001 3:00 PM

Mark, Thanks for the help, but the MOD statement does not give the correct answer. If cell A4 contains the total inches, say 123 then the answer is correct, but if cell A4 contains 18 inches the answer comes back as 2 ft 6 in. I tiped in =TEXT(A4/12,"0)&" ft "&MOD(A$,12)&" in"
In some cases the answer is correct but on numbers like 18, 30, and others it is incorrect.
Thanks Jim


Posted by Mark W. on January 24, 2001 3:20 PM

Sorry Jim, I responded from home without the benefit
of Excel to check my solution. The problem isn't the
MOD() function. I forgot that the TEXT() function will
round. Use this instead:

=TRUNC(A4/12)&" ft "&MOD(A4,12)&" in"

Posted by WES on February 06, 2001 12:14 PM

I HAVE A SIMULAR PROBLEM BUT I NEED TO KNOW HOW TO MAKE THE INCH SECTION ONLY 3 SPACES

EXAMPLE 102" DIAMETER = 26'-8.442"

Posted by Celia on February 06, 2001 4:36 PM


WES
If you just want to convert 102" to ft/inches then :-
=TRUNC(A4/12)&" ft "&ROUND(MOD(A4,12),3)&" in"

If you first want to convert the 102" diameter to the circle area (as in your example) and then to ft/inches :-
=TRUNC(PI()*A4/12)&" ft "&ROUND(MOD(PI()*A4,12),3)&" in"

Celia