View Single Post
  #2   Report Post  
Lisa Files
 
Posts: n/a
Default

A circular reference means you are trying to create a formula with the answer
in the question. ie. add cells A2 + A3 with be equal in A4. A circular
reference will occure when A2 + A3 + A4 is equaled out in cell A4.

Make sure to check your formulas by pressing (and holding) Ctrl + ~ (left of
the #1)

"Colin2u" wrote:

what is it and how do you correct it