Rounding or not rounding

[Guest]

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

 

[Guest]

Maybe.......

=MROUND(A1/25.4,0.5)

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

=ROUND(value/0.5,0)*0.5


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

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

 

[Guest]

Maybe..........

=ROUNDUP(A1/25.4,0)

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Why then do you state that you want

11.515 rounded to 11.5

..515 is greater than .5

?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Guest]

I am posting this question for someone else. I think my information is not
complete nor clear. We have a chart of sizes from metric to imperial, using
"hard conversion". It appears to be inconsistent, so I think we will work
with the formulas both of you have given and leave it at that. Thank you for
taking the time to answer. I appreciate it very much. Sorry for the
confusion. Connie