A strange problem

Giganews Newsgroups
Subject: A strange problem
Posted by:  Pro (nospam@spam.com)
Date: Thu, 9 Oct 2003

Hi,

I'm using Excel 2000 to make a calculation for the following.

Column C =3DB/A
The result show at the last row which using sum(range) and the column C =
at last row is also using B/A.
It is very strange that the result showing 8.52242 instead of 7.XXXXXX.
Is it a calculation error or bug in Excel?

      A
      645 B
      5000 C
      7.75194=20
      177 1375 7.76836=20
      23 176.6 7.67826=20
      1000 7800 7.80000=20
      309 2388.7 7.73042=20
      822 6353.8 7.72968=20
      745 5781.6 7.76054=20
      321.5 2501 7.77916=20
      1180.5 9142.6 7.74468=20
      1698 13135.4 7.73581=20
      1000 7807.4 7.80740=20
      1082 8368.9 7.73466=20
      375 2900.1 7.73360=20
      648.1 5028.9 7.75945=20
      515 4000 7.76699=20
      465.5 3596.9 7.72696=20
      3146.89 24545.74 7.80000=20
      14153.49 109902.6 7.76506=20
      -14838.1 -115737 7.80000=20

      -684.62=20
      -5834.62=20
      8.52242=20

Replies