Maybe.......

=MROUND(A1/25.4,0.5)

Vaya con Dios,
Chuck, CABGx3





"Connie Martin" wrote:

I have this simple formula =A1/25.4 but I want it to yield one decimal only
when it is 5 and under. Above .5 decimal, I want it to go to the next whole
number. For example: An answer of 11.8124 would equal simply 12, but 11.515
would equal 11.5. Thank you Connie