Below are common errors in excel and their definitions:
#N/A - generally indicates that a formula can’t find what it’s been asked to look for.
#VALUE! - something wrong with the formula OR the cells you are referencing.
#REF! - shows when a formula refers to a cell that’s not valid.
#DIV/0! - when a number is divided by zero (0).
#NUM! - a formula or function contains numeric values that aren’t valid.
#NAME? - there is a typo in the formula name. Example COUNTIF not COUNTIIIF.
#NULL! - specify an intersection of two areas that do not intersect.
IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
Syntax: IFERROR(value, value_if_error)
Example: IFERROR(2/X,"Error")
if X = 1, RESULT = 2
if X = 0, RESULT = Error
Stop searching. Start learning and developing your excel skills.
Other Excel Tutorials:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment