Error Handling – English Page

Spread the love

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”

ISBLANK-ExcelIndhindi.com

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

ISError-ExcelIndhindi.com

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

IsEven-ExcelIndhindi.com

  • 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

ISNA-ExcelIndhindi.com

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

ISNONTEXT-ExcelIndhindi.com

  •  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

IsNumeric-ExcelIndhindi.com