sum inaccurate

[Terry]

Hi

Win XP Home
Office 2002

I have an excel workbook with some 6 spreadheets.
B19(Ref' from another s/s in w/book) multiply by:
F19 (also reference to another part of s/s)

My problem basically is for excel to calculate 12 (B19) x 232 (F19),in the
same S/S.. it gives answer as 2790, and SHOULD be 2784 if my math's are
correct?

I suspect I am not applying excel "rules" somewhere?

TIA

 

[Peter Andrews]

Hi

Win XP Home
Office 2002

I have an excel workbook with some 6 spreadheets.
B19(Ref' from another s/s in w/book) multiply by:
F19 (also reference to another part of s/s)

My problem basically is for excel to calculate 12 (B19) x 232 (F19),in the
same S/S.. it gives answer as 2790, and SHOULD be 2784 if my math's are
correct?

I suspect I am not applying excel "rules" somewhere?

TIA

Is it possible that your 232 is actually 232.5 as that would give 2790.

Peter

 

[Alan]

It's probably a rounding problem, eg 6.36 * 3.213 displays 20.43 if the cell
is formated to two decimal places, but the actual result is 20.43468
You can use the ROUND function to avoid this
=ROUND(your formula,2) will round the result to two decimal places,
Regards,
Alan.

 

[Shane Devenshire]

Hi,

Increase the number of decimals places being displayed in B19 and F19.

 

[Terry]

Thank you guys...round did trick.

Terry

Is it possible that your 232 is actually 232.5 as that would give 2790.

Peter