stop excel from rounding a result

H

Hazeldean

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
 
J

JE McGimpsey

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
 
P

Peo Sjoblom

Look what really is in the cell, not what's visible, if you have a formula
copy the cell, paste special as values in an empty cell and look in the
formula bar what the result really is, if you have currency formatted with 2
decimals it will display a rounded result but the underlying value might be
different

see:

http://www.mcgimpsey.com/excel/pennyoff.html

Regards,

Peo Sjoblom
 
Top