Errors in Excel 2007 Calculation

[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

 

[Fred Smith]

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

 

[Ms-Exl-Learner]

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!

 

[Mike Tan]

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