Errors in Excel 2007 Calculation

  • Thread starter Thread starter Mike Tan
  • Start date Start date
M

Mike Tan

Hi,

I'm having problems with Excel 2007

When I total up a number of cells, the value that is shown is 0. For
instance, totalling G3+j3+N3, I get 0. The referenced cells have values
greater than zero

Note: There is a notification of circular reference in one of the cells.
However, I never encountered such a problem with previous versions of excel
(zero value)

Rgds
Mike Tan
 
This result would occur if you had text in the cells rather than numbers.
Text is typically left-justified, rather than right-justified. Is that what
you see?

Another way of checking is to use =istext(g3). If that returns true, you've
found your problem.

Regards,
Fred
 
In which cell you are applying the formula? The circular reference will
occur when the formula intersect with the current cell on which you are
applying the formula.

Remember to Click Yes, if this post helps!
 
Lets say that the cell J3 is a sum of three other cells (eg j4,j5 & j6), and
the circular reference occurs in j5.

As in my previous example, let's say that P3=G3+j3+N3. Although the values
in G3,J3 and N3 are greater than 0, P3 returns a zero value.

Is the main cause the circular reference? Or is there a problem with Excel
:) ?

Rgds
Mike tan
 
Back
Top