"Precision as displayed" works off explicit formatting, not cell widths.
Since it has no effect on your calculation, your values were rounded by
narrow columns instead of explicit formatting.

The cell formula =0.69*800 returns 552. To get 548, the value you
represented as 0.69 must be <0.6861, and its column width must be <5
(assuming 10 point Arial font).

If you want to know what calculation Excel performed, widen the column to
display more figures. If you want to get 552, use the ROUND() function, as
JE McGimpsey suggested.

Jerry

"Abid" wrote:

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 -