ISNA | Excel Hints

Skip to content
Skip to navigation
Skip to footer

May 30 2007

ISNA, ISERROR, and ISBLANK Formula in Excel

Posted by john in ISBLANK, ISERROR, ISNA
3 Comments

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), [...]

TAGS: Excel Formulas, ISBLANK, ISERROR, ISNA

Categories

Controls (7)
- Add Comments (1)
  - Add Comments to Your Spreadsheet
- Column Headers (1)
  - Print Column Headers On Each Page
- Drop Down Menu (1)
  - Create a Drop Down Menu in a Cell
- Formatting (1)
  - Protect Cell Formats
- Hide Formulas (0)
- Keyboard Shortcuts (1)
  - Excel Keyboard Shortcuts
- Protection (1)
  - Protect Cell Formats
- Select Whole Sheet (1)
  - Quickly Select Entire Sheet
Excel Formulas (25)
- Concatenate (1)
  - Concatenate Formula in Excel
- CountA (1)
  - COUNTA and COUNTBLANK Formulas in Excel
- CountBlank (1)
  - COUNTA and COUNTBLANK Formulas in Excel
- CountIf (2)
  - Quick Way to Check for Duplicates in a Column
  - Sumif and Countif Formulas in Excel
- Date (1)
  - Date Formulas in Excel
- HLookup (1)
  - HLookup in Excel
- Hyperlink (1)
  - Hyperlink Formula in Excel
- ISBLANK (1)
  - ISNA, ISERROR, and ISBLANK Formula in Excel
- ISERROR (1)
  - ISNA, ISERROR, and ISBLANK Formula in Excel
- ISNA (1)
  - ISNA, ISERROR, and ISBLANK Formula in Excel
- Large (1)
  - Find the 2nd Largest Value in a Range
- Left (1)
  - Left, Right and Mid Formulas in Excel
- Length (1)
  - Excel Length Formula
- Loan Payment Calc (1)
  - Calculate a Loan Payment in Excel
- Match (1)
  - Match Formula in Excel
- Mid (1)
  - Left, Right and Mid Formulas in Excel
- Rank (1)
  - Rank Formula in Excel
- Right (1)
  - Left, Right and Mid Formulas in Excel
- Small (1)
  - Find the 2nd Largest Value in a Range
- Substitute (1)
  - Substitute Formula
- SumIf (1)
  - Sumif and Countif Formulas in Excel
- Today (1)
  - Today() Formula in Excel
- Trim (1)
  - Excel Trim Formula
- VLookup (1)
  - VLookup in Excel
Excel Forum (2)
- Excel Hints Redesign
- New Excel Forum
Excel Info (1)
- Browser Based Excel
Excel Macros (7)
- Count (1)
  - Count Rows with Data in a Macro
- Loops (1)
  - Using a For Loop in a Macro
- Record a Macro (1)
  - Use the Record Macro Feature in Excel
- Status Bar Messages (1)
  - Using the Status Bar to Display Messages
- Adding an Excel Macro Section to Excel Hints
- Familiarizing With the Visual Basic Editor
- Macro tips on Excel Hints
Poll Results (1)
- Excel Version (1)
  - What Version Of Excel Do You Use?
Site Updates (7)

Excel Poll of the Week

Loading ...

Most Viewed

Excel Keyboard Shortcuts - 2,409 views
Hyperlink Formula in Excel - 776 views
Rank Formula in Excel - 630 views
ISNA, ISERROR, and ISBLANK For... - 626 views
Using a For Loop in a Macro - 607 views
VLookup in Excel - 604 views
Quick Way to Check for Duplica... - 565 views
Excel Trim Formula - 557 views
Count Rows with Data in a Macr... - 523 views
Concatenate Formula in Excel - 490 views