ExcelBanter - Mround

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

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

- - Mround (https://www.excelbanter.com/excel-discussion-misc-queries/28951-mround.html)

ynissel

Mround

I want to round to the 1/8, is there are way to do it which always goes to
the highest 1/8 as opposed to closest 1/8 ?
Thanks

JE McGimpsey

One way:

=CEILING(A1, 0.125)

In article ,
"ynissel" wrote:

I want to round to the 1/8, is there are way to do it which always goes to
the highest 1/8 as opposed to closest 1/8 ?

All times are GMT +1. The time now is 06:21 PM.