1. Check for any spelling mistakes or wrong characters in the formula
2. Ensure the correct arguments are being used
3. Make sure all cited ranges of cells are accurate and not overlapping
4. Check if any cells have been hidden or blocked from view
5. If using external formulas, check for any applicable data changes