Friday, 14 September 2012

Error Type and Reason

#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

No comments:

Post a Comment