Could you give an example? Does it happen all the time? How are you
rounding?

Check that your value is really stored as it's shown. For instance, if
your formula is

A2: =ROUND(A1,0)

and A1 displays

2.500

you might expect it to round to 3. If it really rounds to 2, expand the
number of decimal places displayed - your value may really be
stored/calculated as

2.49975124123852




In article ,
Hazeldean wrote:

After instal of Office SP3, I now find that Excel rounds simple formula
results up or down when visually the correct answer should be the opposite