MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create Formula To Convert Inches To Feet and Inches?

How do I create a formula in Numbers to convert inches to feet and inches. For example, I could enter 28 in a cell and the next cell would give 2′ 4″.
—–
Jean-Claude

Comments: 3 Responses to “How Do I Create Formula To Convert Inches To Feet and Inches?”

    6 months ago

    Interesting problem. You can get the feet by dividing by 12, naturally. Using FLOOR, you can have it round down, so FLOOR(28/12) gives you 2. Then you can use MOD to get the remainder separately. So MOD(28/12) gives you 4. Then it is just a matter of using CONCATENATE to bring them together and add a single-quote symbol for feet and a space after the feet. The inches symbol, since it is a double-quote is tough, but one way to get around it is to use two single-quote symbols and it looks OK.

    So if the 28 is in cell B2, then cell C2 can get the answer with:
    =CONCATENATE(FLOOR(B2÷12,1),"' ",MOD(B2,12),"''")

    Jean-Claude
    6 months ago

    Gary, thanks so much for taking the time to help me on this! I don’t think I would have been able to figure this one out. I have one question : in B2÷12,1 what does the 1 do?

    6 months ago

    Jean-Claude: Look up the FLOOR function in the help. The second number is the closest multiple factor. If you wanted to round 173 down to the nearest 10, you could do FLOOR(173,10) to get 170.

Comments Closed.