Thread: sum inaccurate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Andrews Peter Andrews is offline
external usenet poster
 
Posts: 4
Default 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