# Error Handling – English Page

Error Handling Formulas –

• All the formulas check for single value , if value tested result is ok, so it reflects True else False
• It is very useful to find the errors and data cleaning
• For batter use – Use “if” formula with the formulas to input certain values instead of True False
• IF formulas examples for your help

•  ISBLANK – It verifies the value , is cell blank , if tested ok then it will show “True”

•  ISERROR – It verifies the value , is there any error (like “#N/A”,”Div” etc.)  , if tested ok then it will show “True” else “False”

• ISEVEN/ISODD – It verifies the value can be divided by 2 or not,  if tested ok then it will show “True” else “False”

• ISNA – It verifies if value is “#N/A” , if tested ok then it will show “True” else “False”
• Check in snapshot a cell got found the value “#N/A”, so it is showing TRUE

• ISNONTEXT – It verifies that value “is text” or “non-text” (a-z) or special/wild character , then formula result will True else False

•  ISNUMBER – It verifies, is cell value number , if tested result are ok then it will show True Else False
•  Example – Check in snapshot , both values are numeric , this is why formula results are True