C
Colin2u
what is it and how do you correct it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lisa Files
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)
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)
N
Niek Otten
If you get the circular reference message, click on Help
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
P
Paul Sheppard
A Circular Reference is created when a formula refers back to its ow
cell, either directly or indirectly.
The Circular Reference toolbar indicates the reference of the cel
containing the circular reference. If you look at the formula or th
Status bar (at the bottom of the sheet), you can pinpoint the source o
the error and correct it
cell, either directly or indirectly.
The Circular Reference toolbar indicates the reference of the cel
containing the circular reference. If you look at the formula or th
Status bar (at the bottom of the sheet), you can pinpoint the source o
the error and correct it