Error Type and Reason : Error Type « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Error Type

#DIV/0!:Divide by 0

#N/A! :Cannot find the referenced data

#NAME? :text in a formula is not recognized

#NULL! :Missing Parameters

#NUM! :Numeric data is invalid for the operation type

#REF! :A reference is invalid

#VALUE!:Wrong type of operand or function argument is used

6.14.Error Type
6.14.1.Error Type and Reason