answersLogoWhite

0

B1 is a relative reference.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What does b1 in excel mean?

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


Is the cell address b1 a mixed reference?

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


The excel formula for raising a number in cell B1 to the power in cell C1 is?

=b1^c1


Is B1 correct?

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


In excel if the formula equals A1 plus B1 what is the operator?

For =A1+B1, the operator is the plus sign (+).


How do you write an excel formula to find the gross margin percent if A1 is cost and B1 is retail?

"=((B1-A1)/B1)*100" alternatively if you format the cell as a %, it would just be "=(b1-a1)/b1"


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


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


When should you make a reference cell absolute?

By default, in a spreadsheet like Excel, if you have a reference to a cell, like A1, when you copy the formula down (for example, the A1 is changed to A2, A3, etc. An absolute reference is one where the cell reference does not change when a formula is copied. In Excel, this is indicated by dollar signs. For example, $A$1 means that neither the "A" nor the "1" will change, when the formula is copied.By default, in a spreadsheet like Excel, if you have a reference to a cell, like A1, when you copy the formula down (for example, the A1 is changed to A2, A3, etc. An absolute reference is one where the cell reference does not change when a formula is copied. In Excel, this is indicated by dollar signs. For example, $A$1 means that neither the "A" nor the "1" will change, when the formula is copied.By default, in a spreadsheet like Excel, if you have a reference to a cell, like A1, when you copy the formula down (for example, the A1 is changed to A2, A3, etc. An absolute reference is one where the cell reference does not change when a formula is copied. In Excel, this is indicated by dollar signs. For example, $A$1 means that neither the "A" nor the "1" will change, when the formula is copied.By default, in a spreadsheet like Excel, if you have a reference to a cell, like A1, when you copy the formula down (for example, the A1 is changed to A2, A3, etc. An absolute reference is one where the cell reference does not change when a formula is copied. In Excel, this is indicated by dollar signs. For example, $A$1 means that neither the "A" nor the "1" will change, when the formula is copied.


How to reference an Excel sheet in a formula or function?

To reference an Excel sheet in a formula or function, you can use the sheet name followed by an exclamation mark (!) before the cell reference. For example, to reference cell A1 in a sheet named "Sheet1", you would write "Sheet1!A1" in the formula.


What is the cell address of the last cell of the Microsoft Excel 2003?

The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.The cell reference for the last cell in Excel 2003 is cell IV65536.


What formula would you use in Excel to add cells b1 and b2 together?

You could use either of the following, by putting the formulas in any cells except A1 and B1: =A1+B1 =SUM(A1:B1)