You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
What would be the correct way to type feet and inches (not decimal form), in a cell in Numbers? I would like to add them up too.
Example:
A1- 5’7”
A2- 6’1”
A3- 5’8”
A4- the total of A1 thru A3
iPhone 12 Pro Max, iOS 16
Hi Jed,
Use a column for feet and another column for inches.
I have added a Header row and a Header column for labels.
Formula in D2: IF(OR(B2="",C2=""),"",B2&"'"&C2&"""")
Fill down to Row 5.
Formula in B5: SUM(B2:B4)
Fill right to C5
Now to convert the totals to real feet and inches.
Formula in B6: B5+INT(B5÷12)
Formula in C6: MOD(C5,12)
Another example
Regards,
Ian.
Hi Jed,
Use a column for feet and another column for inches.
I have added a Header row and a Header column for labels.
Formula in D2: IF(OR(B2="",C2=""),"",B2&"'"&C2&"""")
Fill down to Row 5.
Formula in B5: SUM(B2:B4)
Fill right to C5
Now to convert the totals to real feet and inches.
Formula in B6: B5+INT(B5÷12)
Formula in C6: MOD(C5,12)
Another example
Regards,
Ian.
Hi Ian,
Thank you for the answer. Very helpful too.
jed
Feet and Inches Format in Numbers
