Maybe..........

=ROUNDUP(A1/25.4,0)

Vaya con Dios,
Chuck, CABGx3



"Connie Martin" wrote:

This ALMOST works. Don't know why it works with some numbers and not others.
for example: 69/25.4 = 2.716535, but using the MROUND formula below it
rounds it to 2.5. It should round it to 3 because it's above .5 decimal.
Connie

"CLR" wrote:

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