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