sum inaccurate
 

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

sum inaccurate
 

"Terry" wrote in message
...
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

sum inaccurate
 

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.
"Terry" wrote in message
...
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

sum inaccurate
 

Hi,

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


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Terry" wrote:

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

sum inaccurate
 

Thank you guys...round did trick.

Terry
"Peter Andrews" wrote in message
...

"Terry" wrote in message
...
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