0
With a regular formula you cannot change the value in another cell. So it is not possible to have a formula in one cell that changes a value in another cell. You can reference a value in another cell. You can type the address of a cell into another cell and then using a formula you can check a cell for the address of another cell and get the value from that other cell. The INDIRECT function can be used to do this. Say you put 10 in cell C1 and then type C1 into cell B1. Then if you put =INDIRECT(B1) into cell A1, it will look at cell B1, see C1 is in it and then look at cell C1, which will result in 10 being put into A1. Another function that may be useful is the ADDRESS function, which can be used to identify a cell by picking its row and column numbers.
What else can I help you with?
What 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?
A circular reference occurs when a formula in one cell depends on the value of another cell, which in turn contains a formula that refers back to the original cell. This creates a loop where the two cells continuously reference each other, preventing Excel from calculating a definitive value. As a result, the software may display an error or warning, indicating that it cannot resolve the circular dependency. To resolve this, you typically need to adjust the formulas to eliminate the circularity.
What are the disadvantage of using formula in excel instead of using cell reference?
Using a formula which does not reference any cells means that the result is fixed, as the values are fixed. The result will only change if the formula is changed. Using cell references allows you to have a formula using variables. If the data changes then the result of the formula changes. The question is a little odd however because it is almost certain you will want to, and are able to, use both; cell references within formulas.
What is kinamatics?
The branch of science which deal with motion of bodies without reference of forces which either cause the motion or generated as a result of motion.
What is another way to say positive outcome without using the word positive?
Favourable result.
Can I subtract 270 days from a date and have it post in another cell?
If you put the original date in one cell and the calculation in another cell, then the result will appear in that second cell. So if the date was in cell B3, in cell E5 you could put the following formula: =B3-270 There is no way to type a formula in one cell and have its result appear only in another cell. So if you then wanted to have that result in yet another cell too, then you could put the following into your third cell: =E5 The result of the formula will now be in E5 and the other cell you specified. If at any stage the result in E5 changes, like if you changed the calculation or the original date, both E5 and the cell you made equal to it will both change immediately.
A possiblity with reference to a doubtful result?
Chance
Is it true that the Cell A1 contains 5 and B1 contains 10 What will be the result of the formula?
You have not specified a formula, so it depends on what you are doing. You could be adding them or subtracting them or multiplying them or dividing them or averaging them etc. Without a specific formula, then there is no answer to your question.
How do you listen to another person conversation without informing him or her?
Doing this is illegal, This could result in jail time.
What is the definition of frame of reference in scientific terms?
A frame of reference is a coordinate system that defines the position and motion of an object. It is used to describe the motion of an object relative to another point or observer. Different frames of reference can result in different observations of the same event.
What is value seek in Excel?
You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.
What can be assigned to a cell and will display calculated a result?
Formula
How do you specify that the cell address will change if copied to another cell in excel?
No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.No special activity is done to do this. Typing a cell reference in the normal way will result in a cell reference changing if it is copied. It is known as a relative reference. To restrict the change, you can make the cell mixed or absolute. See the related question below.
