ExcelBanter - Rounding up to the nearest 1/8"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rounding up to the nearest 1/8" (https://www.excelbanter.com/excel-discussion-misc-queries/188214-rounding-up-nearest-1-8-a.html)

rudyeb

Rounding up to the nearest 1/8"

What is the formula I would write to have a result be rounded up to
the enarest 1/8"?

Thanks,

David Biddulph[_2_]

Rounding up to the nearest 1/8"

=CEILING(A1,1/8)
assuming that your number is in inches.
--
David Biddulph

"rudyeb" wrote in message
...
What is the formula I would write to have a result be rounded up to
the enarest 1/8"?

Thanks,

All times are GMT +1. The time now is 02:30 AM.