Rounding to point 5
 

I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to 79
if the cell has a calculated value between 79.26 and 79.74, it should round
to 79.5

Thanks,

Regards,

Art

Rounding to point 5
 

=ROUND(A1/0.5,0)*0.5


--

Regards,

Peo Sjoblom


"hddude52" wrote in message
...
I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to
79
if the cell has a calculated value between 79.26 and 79.74, it should
round
to 79.5

Thanks,

Regards,

Art

Rounding to point 5
 

Note that 79.25 rounds to 79.50


--

Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=ROUND(A1/0.5,0)*0.5


--

Regards,

Peo Sjoblom


"hddude52" wrote in message
...
I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to
79
if the cell has a calculated value between 79.26 and 79.74, it should
round
to 79.5

Thanks,

Regards,

Art

Rounding to point 5
 

=MROUND(A1,0.5)
--
David Biddulph

"hddude52" wrote in message
...
I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to
79
if the cell has a calculated value between 79.26 and 79.74, it should
round
to 79.5

Thanks,

Regards,

Art

Rounding to point 5
 

This worked fine and will fit the need.

Thanks PEO

David, your formula returned a NAME? error that I couldn't identify

Thanks to both of you
--
Regards,

Art


"Peo Sjoblom" wrote:

=ROUND(A1/0.5,0)*0.5


--

Regards,

Peo Sjoblom


"hddude52" wrote in message
...
I would like help in writing a formula to round to .5. an example is:

a cell has a calculated value of between, 78.75 to 79.25 should round to
79
if the cell has a calculated value between 79.26 and 79.74, it should
round
to 79.5

Thanks,

Regards,

Art

Rounding to point 5
 

And did you look at what Excel help said about the MROUND function?
--
David Biddulph

"hddude52" wrote in message
...

David, your formula returned a NAME? error that I couldn't identify
....