###### Asked in Uncategorized

Uncategorized

# An circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell?

**We need you to answer this question!**

###### If you know the answer to this question, please register to join our limited beta program and start the conversation right now!

## Related Questions

###### Asked in Microsoft Excel

### What is a formula in a cell that contains a reference to itself in Excel?

It creates what is known as a circular reference. It is not
allowed so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.
It creates what is known as a circular reference. It is not allowed
so the formula is invalid, as it creates infinity.

###### Asked in Microsoft Excel

### What kind of refernce is a formula that depends on its own value?

A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.
A circular reference. It will cause an error.

###### Asked in Microsoft Excel

### Is there a formula in Excel that will allow a cell to subtract from itself the amount entered into another cell?

No. A cell cannot reference itself in a formula. That creates
what is known as a circular referenceIt also cannot have both a
value in it and a formula doing something to that value. So you
would use a different cell for the formula. Put the original total
in one cell, the amount to subtract in another cell and a formula
in another cell that will be the original total cell minus the
amount to be subtracted cell. So if your original value is in A2
and the amount to be subtracted in B2, then in C2 you could
put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2
No. A cell cannot reference itself in a formula. That creates what
is known as a circular referenceIt also cannot have both a value in
it and a formula doing something to that value. So you would use a
different cell for the formula. Put the original total in one cell,
the amount to subtract in another cell and a formula in another
cell that will be the original total cell minus the amount to be
subtracted cell. So if your original value is in A2 and the amount
to be subtracted in B2, then in C2 you could put:
=A2-B2

###### Asked in Microsoft Excel

### What is a circular reference in Microsoft Excel?

A circular reference usually happens when a formula refers to
the cell that it is in. So it could be doing something like adding
itself to itself or including itself when totalling a group of
cells. That creates an infinity situation as it keeps referring
back to itself, causing a circular reference. It can also happen
when it refers to another cell that refers to the cell that the
formula is in. If you have a circular reference it is usually a
matter or excluding the cell reference of the cell that the formula
is in from within the formula. For more complex circular references
it may be a case of reviewing the logic of your spreadsheet. This
can always be done.

###### Asked in Microsoft Excel

### How do you fix circular data in Excel?

A circular reference error is caused when a formula directly or
indirectly refers to the cell that the formula has been typed in.
When this happens you will see the cell that the circular reference
is in at the bottom of the worksheet. You need to check the formula
in that cell and formulas in other cells that it refers to in order
to find the problem. Then you can change the formula so that you
can still do what you want without the error.

###### Asked in Microsoft Excel

### Does a named range change when it is copied as part of a formula?

If a formula copied includes the actual name of a range, then
when you copy it, the name will stay and so will the reference to
the original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.
If a formula copied includes the actual name of a range, then when
you copy it, the name will stay and so will the reference to the
original set of cells the range refers to.

###### Asked in Microsoft Excel

### What is the formula that contains an absolute cell reference?

Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.
Any formula can contain an absolute cell reference. There is no
special name for a formula with an absolute reference in it.

###### Asked in Microsoft Excel

### Is it true that a formula can consist of a single cell reference?

It is possible for a formula not to have any cell references.
Lots of functions do not use any values. To show the current date
you could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4
It is possible for a formula not to have any cell references. Lots
of functions do not use any values. To show the current date you
could have the following in a formula:
=TODAY()
You could have a formula with a single cell reference with some
operation being done on it:
=B4*10
You can have a formula that just has a cell reference which will
just request that the current cell displays what is seen in another
cell:
=B4

###### Asked in Microsoft Excel

### What is circular reference for Microsoft Excel?

A formula cannot refer to the cell it is in. If it does, it is a
circular reference. If you put =A4+5 into cell A4, then the formula
is telling it to add 5 to the total in the cell. That will give a
new total, which is then being asked to add 5 to itself, giving a
new total, which is then being asked to add 5 to itself and that
would go on forever. It is not possible to get an answer. It will
go around forever, like a circle, hence the name. So a formula can
not directly or indirectly refer to the cell it is in.

###### Asked in Microsoft Excel

### In Excel if a formula is assigned to a cell can Excel calculate the result?

As a general rule, a formula can refer to any cell on the
spreadsheet except the cell that the formula is in. So if you are
typing a formula into cell B10, then the formula cannot use B10 as
part of the formula, but it can use any other cell. With more
complex spreadsheets a formula cannot refer to another formula that
refers to the cell of the original formula. So a formula in B10
could not refer to another cell that has a formula that uses B10 as
part of its formula. Any of these situations are known as circular
references and are not allowed in a spreadsheet. So the broader
rule is that a formula cannot refer to the cell it is in itself
either directly or indirectly through other formulas.

Load More