Farmula wrong result

[Abid]

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

 

[Guest]

from the immediate window:

? 0.69*800
552

works fine for me.

You say some calculations, so perhaps those really are not the numbers being
multiplied.

 

[Don Guillett]

Pls post in only ONE group

 

[JE McGimpsey]

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)

 

[Carl Hartness]

Could calculate be set to manual, so that the 448 is from a previous
calculation?

Carl.

 

[Abid]

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

 

[Guest]

"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