Excel errors (#N/A, #VALUE!, #REF!, #NAME?, #DIV/0!): what they mean and how to fix them
Your spreadsheet shows #N/A, #VALUE!, #REF!, #NAME?, #DIV/0!, #SPILL! or #####? Here’s what each Excel error means and how to fix it — without just hiding the problem.