Excel Guides

The 10 Most Common Text Values in Excel

1. #NULL! - The #NULL! error value indicates that a formula is referring to an intersection of two areas that do not intersect. This can happen when a formula refers to a range of cells that do not intersect, or when a name is used in a formula that does not correspond to a defined name.

2. #DIV/0! - The #DIV/0! error value indicates that a formula is trying to divide by zero. This can happen when a formula divides a number by another number that is equal to zero, or when a formula refers to a cell that contains the value zero.

3. #VALUE! - The #VALUE! error value indicates that a formula is referencing a cell that contains a value that is not a number. This can happen when a formula refers to a cell that contains text, or when a formula refers to a cell that contains a date or time value that is not a number.

4. #REF! - The #REF! error value indicates that a formula is referencing a cell that does not exist. This can happen when a formula refers to a cell that has been deleted, or when a formula refers to a cell in a worksheet that has been renamed.

5. #NAME? - The #NAME? error value indicates that a formula is referencing a name that does not exist. This can happen when a formula refers to a name that has been deleted, or when a formula refers to a cell that contains a name that is not defined.

6. #NUM! - The #NUM! error value indicates that a formula is referencing a number that is not valid. This can happen when a formula refers to a number that is too large or too small, or when a formula refers to a cell that contains a number that is not a valid number.

7. #N/A - The #N/A error value indicates that a formula is referencing a cell that does not contain a value. This can happen when a formula refers to a cell that is empty, or when a formula refers to a cell that does not exist.

8. #GETTING_DATA - The #GETTING_DATA error value indicates that a formula is referencing a cell that is not yet available. This can happen when a formula is referencing a cell that is being updated by another formula, or when a formula is referencing a cell that is not yet available.

9. #ERROR! - The #ERROR! error value indicates that a formula is referencing a cell that contains an error. This can happen when a formula refers to a cell that contains a #NULL! error, a #DIV/0! error, a #VALUE! error, a #REF! error, or a #NAME? error.

10. #N/A N/A - The #N/A N/A error value indicates that a formula is referencing a cell that does not contain a value. This can happen when a formula refers to a cell that is empty, or when a formula refers to a cell that does not exist.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.