1. | #N/A - Vlookup not found | |
2. | #NAME - cell reference doesn't exist | |
3. | #DIV/0 - formula is dividing by 0 use =if(a1=0,) | |
4. | #REF! - referring to a cell that's been moved or row that was deleted | |
5. | Step through formula calculation - Formulas > Formula Auditing > Evaluate Formula | |
6. | Circular Reference - in cell A1 and the formula =A1 | |
7. | External Link | |
8. | #VALUE! - the parameter to the function exceeded 255 characters or adding a string with a number | |
9. | Data not recalculating - Check options to see that Calculations set to Automatic |