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.
I am creating a spreadsheet in Numbers for roof framing. the design is simple. some of the returned data is fractional. it is not usable to me because the fractions are sometimes such as this 26/33. I need the returned data in fractional terms to be in halfs, quarters, eighths, or sixteenths. in other words, I need the returned data from formulas to be usable on an imperial tape measure. thanks
iMac 24″, macOS 14.5
Hi Leigh,
LeighMorgan2817 wrote:
I need the returned data in fractional terms to be in halfs, quarters, eighths, or sixteenths. in other words, I need the returned data from formulas to be usable on an imperial tape measure. thanks
From where are your data returning? What are your input data? Perhaps from an imperial tape measure to a Numbers table?
What are your formulas?
More information (and a screen shot showing your table with formulas) may help us to help you.
Regards,
Ian.
You have not replied for 2 days.
In case you are still interested, I will take a guess on your overall aim.
Feet and Inches Format in Numbers - Apple Community
Regards,
Ian.
Something like this maybe, as long as all the results are positive numbers:
=MROUND(your_current_formula,1÷16)
rounding fractions in Numbers
