Information functions become more powerful when combined with IF, AND, OR, and IFERROR.

Example — Data Validation

Employee

Salary

Status

Amit

35000

  

Neha

42000

  

Rahul

Text

  

Priya

48000

  

Formula:

=IF(ISNUMBER(B2),”Valid Salary”,”Check Data”)

If B2 contains a number:

Valid Salary

If B2 contains text:

Check Data

Example — Blank Cell Check

=IF(ISBLANK(A2),”Missing”,”Available”)

Example — Error Check

=IF(ISERROR(B2),”Error Found”,”Valid”)

Example — Formula Check

=IF(ISFORMULA(B2),”Formula”,”Manual Entry”)

Practice

Create a Data Quality Checker that identifies:

  • Missing data
  • Text instead of numbers
  • Formula cells
  • Errors
  • Valid data
PreviousNext