GOAL SEEKING -- You can use the Goal Seek facility.
Goal Seeking
Goal Seek.
It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.It displays what is called the Cell Contents. The Cell Contents are what was originally typed into the cell. If that is only a value, then it displays the value. If it is a formula, then you will see the formula that was entered. In the cell itself you will normally see the result of that formula, unless the worksheet has been set to show the formulas.
There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.
=E5/E6
The proper name is the formula bar, but yes a formula or value can be seen there when you have entered a value or formula in a cell.
You can literally type in a new value into a cell. It can also be changed by using controls, such as scroll bars, dropdown lists, spinners etc. The value a cell has may change as a result of a formula, though tecjhnically if it has a formula in it, then that is not really a value even if it shows a value, as what is actually stored in the cell is a formula.
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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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-B2No. 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
The Solver.
The Formula Bar.
That depends what you mean by the desired results. The "Set Cell" refers to the cell that has a formula and will show the result of a calculation. If that is the cell you mean by desired results, and most likely it is, then it is the "Set Cell" box. The "By Changing" defines which cell has a value in it that can be changed to give a particular result for the formula. So if you mean the desired result being finding which value makes the formula give you the total you want, then it is the "By Changing" box.
A dependent is a cell that a formula depends on. The cells mentioned in a formula are its dependents.
Unless you're entering it into cell G15, you'll put the value from G15 into the cell you're entering into.
The formula bar.