answersLogoWhite

0

No. B1 is a relative reference. $B1 or B$1 are mixed references. See the related question below.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What type of cell reference is C13?

It is a relative reference. If the formula =A1+A2 is copied to B1 then the formula changes to =B1+B2


What does a cell at the intersection of the first row and second column have as the cell reference?

B1


A cell at the intersection of the first row and second column has the cell reference?

B1


The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

Technically it is not a cell reference, because it is referring to a range of cells, not just one cell. The reference would be: B1:G10


Is B1 correct?

In Excel, B1 is a cell address where column B and row 1 meet.


Is a syntax B1-B2B3 is an example of formula in excel?

No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3No. There is no equals sign at the start and the cell reference B2B3 is not valid or has an operator missing. A possible formula variation on it could be:=B1-B2+B3


The address of a cell based on the relative position of the cell that contains their formula and the cell?

To reference a cell relative to the one containing the formula, you can use relative cell references. For example, if the formula is in cell A1 and you want to reference the cell one column to the right, you can use B1. If you want to reference the cell one row down, you can use A2. This way, the reference adjusts based on the formula's location.


What does b1 in excel mean?

That is the reference for the cell at Column B, Row 1.


What reference of Excel is an example of B1?

B1 is a relative reference.


What is a relative cell reference in Excel?

relative cell reference


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.


How can i reference a cell range in a formula from another cell Instead of equals SumB2 to B11 i want to write equals sumB1 to B A1 so that the range is detrmined by the value in cell A1?

Here is how to determine both start and end of the SUM range on the fly:In A1, put the address of the start cell [D3]In B1, put the address of the end cell [M3]In C1 put the formula =SUM(INDIRECT(A1 & ":" & B1))[Observe the same as =SUM(D3:M3)]The INDIRECT function lets you use the value in the identified cell (like a variable).