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
Something like this maybe, as long as all the results are positive numbers:
=MROUND(your_current_formula,1÷16)
Something like this maybe, as long as all the results are positive numbers:
=MROUND(your_current_formula,1÷16)
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.
rounding fractions in Numbers
