0
If you copy the formula SB38 into another cell the result will be?
Wiki User
∙ 11y ago
First of all, SB38 is not a formula, and neither is $B38 if that is what you mean. It needs to have an equals sign before it. If it does, then it depends on where it is copied as to what the new formula will be. If it is =SB38 then there are lots of ways it will change. If it is $B38, then the B will not change wherever it is copied, but the 38 will.
Wiki User
∙ 11y ago
Suresh Chudasama
Chodu
Add your answer:
Earn +20 pts
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.
Is there a way to reference a value in a cell in Excel using a formula in another cell and then based on the result paste a value into a target cell without using VBA or Macro?
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 can be assigned to a cell and will display calculated a result?
Formula
In Excel what can be assigned to a cell that will display a calculated result?
formula
Does the formula bar in Excel display the value or formula of an active cell?
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.
When a formula is in an active cell the underlying formula is visible in the what Formula Bar or Worksheet or Status bar or Name Box?
If there is a formula in the active cell, then the formula will be displayed in the formula bar and the result of the formula will appear in the cell.
In excel if value is in one column automaticlly put formula in another column?
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.
What is the difference between a cell name and the data stored in a cell?
The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.The cell name can be something like C3 or F22 or K29, or it can be given an actual name. Using a cell address we can refer to the cell. What is in the cell is the cell contents which can be data or a formula. When we use a formula we refer to the cell address and the formula uses the content of the cell. If 10 was in cell C3 and 20 was in cell C4 then you could use the following formula:=C3+C4The result would be 30, as the formula uses the content of the cells.
Does the sizing handle allow you to copy a formula from 1 cell to another cell?
If the formula is something like AVERAGE, SUM, etc., then it will copy it to another cell. However, when using the sizing handle after just entering the formula alone, Excel will automatically fill in the answer. The formula is copied along with it, though. However, if the formula is in reference to the content of another cell, this will not happen. The formula changes if the formula uses the content of another cell. To keep it exactly the same to copy it down, you have to make the cell number in the formula an absolute value so it will not change.
In excel 2007 is there a formula to print the last two digits of a five digit number into another cell?
In cell A1 enter [12345].In cell B1 enter [=RIGHT(A1,2)].Observe in cell B1 the result [45].
Excel function that allows you to set the value in a single cell in a worksheet?
You can use a facility called Goal Seek to try to establish a value in one cell that will produce a specific result for a formula in another cell.
A nested function is placed in the cell below the first formula true or false?
False. A nested function is a function within another function, so it would be in the same formula. An alternative to nesting would be to put a separate function in a different cell and use its result in the other formula. In that case it would not have to be put in the cell below the first formula.
