Excel Tips and Tricks for All Levels

Excel has many built-in formulas that will check for errors for you. Were going to take a look at three of those formulas, which are ISNA, ISBLANK and ISERROR. Let’s start by taking a look at the formulas:
ISNA(value)
ISERROR(value)
ISBLANK(value)
Each of these formulas looks at value and evaluatues whether it is #N/A (with ISNA), #Value (with ISERROR), [...]