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

"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

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

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

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