• If you see “#NAME?” or “#Value?”, check for errors in your equation.
  • #NAME? Occurs when Microsoft Excel doesn't recognize text in a formula
  • #Value? Occurs when wrong type of argument or operand is used

 

  • “########” is not an error. It indicates the cell is too narrow to show the number. Simply increase the width of the column.