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

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

=ROUND(value/0.5,0)*0.5


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Connie Martin" wrote in message
...
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

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

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

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


"Connie Martin" wrote in message
...
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

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


"Peo Sjoblom" wrote:

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


"Connie Martin" wrote in message
...
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