Calculations Error.

I am encountering a problem in my excel calculation. I have a salary sheet in which figures come in fractions. There is a catch in this that I have to round them to the previous figure if the fraction falls below .5. But if the fraction goes from .5 above, it should be rounded to the next figure. Not only that, the sum of these figures should reflect the change. Any solution??