• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

IFERROR in Excel

September 4, 2021 by Andrew Childress
Iferror Excel

When working in Excel, you’ll often find yourself using formulas. You might want an easy way to identify formula errors. Here's how to use IFERROR in Excel.

When you work in Excel spreadsheets, you’ll often find yourself using formulas. But it’s quite easy to make mistakes in these formulas. You might want a quick and easy way to identify errors and make sure they’re clearly visible so that you can correct them. Fortunately, Excel offers a way to do exactly that. Let’s learn how to use IFERROR in Microsoft Excel.

How to Use IFERROR in Excel

Imagine that you have several numbers in a column that you’re dividing by values contained in column B. For example, 500 in cell A1 divided by 2 in cell B1 gives you the value 250 in cell C1. You have multiple rows, but in some rows, you’ve accidentally divided the column A values by 0. You want a fast way to identify this mistake with custom verbiage.

This is where Excel’s IFERROR function comes in. To use it, click into any empty cell on your worksheet. For simplicity, we’ll use cell D1 here. Begin by typing an = sign. This tells Excel that you’re inputting a formula.

Then, type IFERROR(. This adds the IFERROR function to your formula, which now reads:

=IFERROR(

Iferror Excel

Then, type in the formula that you want to find the error in. Here, this is A1/B1:

=IFERROR(A1/B1

Type a comma. Now, it’s time to tell Excel what text you want displayed if Excel finds an error in the formula, which here means dividing by zero. Typing in quotes, add “Divide by Zero!”, then close the parentheses. Your completed IFERROR formula now reads:

=IFERROR(A1/B1,”Divide by Zero!”)

Iferror in Excel

Hit Enter on your keyboard, and Excel will simply return the mathematical value of 250. Finally, copy your formula downward. Notice that the formula in row 2 attempts to divide 75 by 0. Cell D2 with your IFERROR formula will return the Divide by Zero! text.

Excel iferror

As you can see, Excel’s IFERROR feature is a fast, elegant way to identify errors inside your Excel spreadsheet formulas.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Protect Excel WorkbooksProtect Workbook in Excel
Next Post:RATE in ExcelRate function in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top