What does ref mean in excel table

The meaning of ref in the excel table is that the cell reference is invalid. Deleting a cell referenced by other formulas, or pasting a moved cell into a cell referenced by other formulas will produce an error value"# REF!".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

#REF! When the cell reference is invalid, the error value #REF will be generated! .

Cause: Cells referenced by other formulas were deleted, or moved cells were pasted into cells referenced by other formulas.

Extended information:

Common Excel error values

1,

##!

Cause: If the number, date or time contained in the cell is wider than the cell, or the date and time formula of the cell produces a negative value,

## will occur! mistake.

2. #DIV/O! When the formula is divided by zero, the error value #DIV/O! will be generated.

Cause: In the formula, the divisor uses a cell reference that points to an empty cell or a cell containing a zero value (in Excel, if the operand is a blank cell, Excel treats the empty value as a zero value ).

3. #NAME? When text that Excel cannot recognize is used in the formula, the error value #NAME? will be generated.

Cause: The name used in the formula was deleted, or a non-existent name was used.

4, #NULL! When trying to specify an intersection point for two areas that do not intersect, the error value #NULL will be generated! .

Cause: An incorrect range operator or incorrect cell reference was used.

5, #VALUE! When the wrong parameter or operand type is used, or when the formula autocorrect function cannot correct the formula, the error value #VALUE! will be generated.

Cause: Text was entered when a number or logical value was required, and Excel could not convert the text to the correct data type. Related learning recommendations:

excel tutorial######

The above is the detailed content of What does ref mean in excel table. For more information, please follow other related articles on the PHP Chinese website!