Microsoft Office Tutorials and References
In Depth Information
Converting Inches to Feet and Inches
Converting Inches to Feet and Inches
If you ever need to convert inches to feet and inches, you’ll quickly understand the merits of the
metric system. Converting inches to feet and inches is basically a division problem, in which you
need to pay attention to the remainder (leftover inches).
The following formula assumes that cell A2 contains a value that represents inches. The formula
displays the result in feet and inches (for example, if A2 contains 43, the result is 3'7"):
=TEXT(INT(A2/12),”#,##0”)&”’ “&MOD(A2,12)&””””
This formula returns a text string, so you can’t perform mathematical operations on the result. If
you want to convert a feet-and-inches text string back to inches, this formula does the job (it
assumes that cell A1 contains a string such as 9'11"):
=(LEFT(B2,FIND(“’”,B2)-1)+((MID(B2,FIND(“’”,B2)+1,LEN(B2)-
FIND(“’”,B2)-1))/12))*12
These formulas work with positive inches only.
Figure 99-1 shows these formulas in use.
Figure 99-1: Converting inches to feet and inches and then back to inches.
 
Search JabSto ::




Custom Search