MS Excel Error Messages


Excel Error Messages 


Excel lets you know about it with an error message If you create a formula in Excel. A handful of errors can appear in a cell when a formula or function in Excel cannot be resolved. Knowing their meaning helps correct the problem.
ErrorMeaning
#DIV/0!Trying to divide by 0
#N/A!A formula or a function inside a formula cannot find the referenced data
#NAME?Text in the formula is not recognized
#NULL!A space was used in formulas that reference multiple ranges; a comma separates range references
#NUM!A formula has invalid numeric data for the type of operation
#REF!A reference is invalid
#VALUE!The wrong type of operand or function argument is used

Popular posts from this blog

50 Excel VBA Oral Interview Questions