May 30 2007

ISNA, ISERROR, and ISBLANK Formula in Excel

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 […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks