| A | B |
|---|
| Syntax error | You have a problem with the syntax of a formula. |
| Logical error | A formula doesn't return an error, but it contains a logical flaw that causes it to return an incorrect result. |
| Incorrect reference errors | The logic of the formula is correct, but the formula uses an incorrect cell reference. |
| Semantic error | An example is a function name that is spelled incorrectly. |
| Circular reference | A circular reference occurs when a formula refers to its own cell. |
| Array formula entry errorl | When you fail to press Ctrl+Shift+Enter when entering an Array formula. |
| Incomplete calculation error | The formulas simply aren't calculated fully. |
| Mismatched Parentheses | =SUM(A1:A500 |
| Hash Marks | The cell contains a formula that returns an invalid date or time. |
| TRIM function | Removes leading spaces, trailing spaces, multiple spaces within a text string. |
| Find All | If any cells that contain only space characters, Excel will list the cell address at the bottom of the Find and Replace dialog box. |
| #DIV/0! | Division by zero is not a valid operation. |
| IFERROR function | To check for any error condition. |
| #N/A Error | Occrs if any cell referenced by a formula displays #N/A. |
| #NAME? Error | Occurs when the formula contains an undefined range or cell name. |
| #NULL! Error | Occurs when a formula attempts to use an intersection of two ranges that don't actually intersect. |
| #NUM! Error | Occurs when you pass a non-numeric argument to a function when a numeric argument is expected. |
| #REF! Error | Occurs when a formula uses an invalid cell reference |
| #VALUE Error | Occurs when an argument for a function is of an incorrect data type. |
