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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Create Formula To Convert Inches To Feet and Inches?
Comments: 3 Responses to “How Do I Create Formula To Convert Inches To Feet and Inches?”
Comments Closed.
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),"''")
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?
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.