stop excel from rounding a result
 

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

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

Can you give an example of what you are talking about?

On Fri, 13 May 2005 13:57:02 -0700, 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

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

"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