Sorry that s not 448 that s 548 (the differ is only 4).
Tools/Options/Calculation/Precision as displayed = doesnt show any
effect ?

thanks anyway


On Mar 13, 4:44 pm, JE McGimpsey wrote:
Are either or both of your values from calculations? If so, it's likely
that their displayed value is not the actual value stored in the cell,
though 448 is too low for rounding to be the problem (did you mean 548?).

You can use Tools/Options/Calculation/Precision as displayed, but that
affects the entire workbook.

You can also wrap your calculations in ROUND(), e.g., for the value that
displays as 0.69:

=ROUND(<your formula here, 2)

And if you want the value calculated as 800 to be rounded to the nearest
hundred:

=ROUND(<your other formula here, -2)

In article om,



"Abid" wrote:
hi all,

i had some calculations (0.69*800) the result comes to 448 but it s
wrong it should be 552.. any idea plz help me.

thanks- Hide quoted text -

- Show quoted text -