Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Formula

 

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