Farmula wrong result
 

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

Farmula wrong result
 

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.

--
Regards,
Tom Ogilvy

"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

Farmula wrong result
 

Pls post in only ONE group

--
Don Guillett
SalesAid Software

"Abid" wrote in message
ps.com...
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

Farmula wrong result
 

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

Farmula wrong result
 

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

Carl.

On Mar 13, 6:27 am, "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

Farmula wrong result
 

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 -

Farmula wrong result
 

"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 -