I assume you mean a cell on a spreadsheet and not in the body. A cell reference, such as A1, B5, Z77, allows a formula to pin-point and use the data it finds in a specific cell. Likening a cell reference to your home address: without a home address, the poor postman (and woman) would not be able to post your mail through your letterbox.
The #NAME? error indicates the formula references something that Excel does not recognise. It could be the name of function that does exist, which often happens when the user spells the name of a function incorrectly. It could be a cell reference that does not exist. It could be looking for a defined name for a cell or a range that does not exist.
A relative cell reference is one that will change to a different cell if you copy the formula. An absolute reference is one that will always use the same cell. For example, say you have a percentage in cell B1 that you want to add to all the cells from A3 down. In cell B3 you could use the formula '=A3*(1+$B$1)'. If you copy this formula to the cells below B3, the reference to A3 will change to be the cell immediately to the left, because it is a relative cell reference. By adding the $ symbol before the B and the 1, however, an absolute reference is created. It will always refer to cell B1.
yes
You can use both numbers and cell references in formulas.
Relative Cell references
Relative reference
Cell references are the addresses of cells and values are what are contained in the cell. So A3 could be a cell reference and the number 42 could be a value in the cell.
Relative cell references and some mixed cell references will change when a formula is copied.
Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.Cells have cell references which cannot be changed. Cells can be given individual names too, and these can be changed. The cell can then be referenced by its name or cell reference.
If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.If you are talking in terms of cell references, then the dollar sign is used to lock row and/or column references. See the related question below.
If you move a formula, as opposed to copying it, cell references will stay the same.
It would be a formula that includes absolute references in cells. When such a formula is copied, those cell references will not change. An absolute cell reference includes cell references with two dollar signs in them, like: $A$2.