Excel Formulas for Basic error trapping in Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2021-11-01 11:06:52

---
title: Excel Formulas for Basic error trapping in Excel Office 365!!
published: true
date: 2021-10-30 08:11:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-basic-error-trapping-in-excel-office-365/
---

Earlier, we have learned the formulas to **[Excel Formulas to use the basic inventory formula](https://geekexcel.com/excel-formulas-to-use-basic-inventory-formula-quickly/)**. Here, we will guide you to learn the simple and useful  **formulas for basic error trapping** in Excel Office 365. You can also learn the basic syntax with brief explanations. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- You can use the below-mentioned formulas for basic error trapping in Excel.

```
=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)(formula,value_if_error)

```

## Syntax Explanation

- **IFERROR** – The Excel **[IFERROR function](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/) **returns a custom result when a formula generates an error and a standard result when no error is detected.
- **Parenthesis () – **The main purpose of this symbol is to group the elements.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.

## Practical Examples

To use basic error trapping in Excel, refer to the below given example.

- In the following example, you have to create a **sample data**  in Microsoft Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-74.png)<figcaption>Sample data</figcaption>

- To catch errors that a formula might encounter in a worksheet, you need to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=IFERROR(C5/D5,"")

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-27.png)<figcaption>Use the Formula</figcaption>

- Now, you need to  **Hit**  the  **Enter**  key to get the  **result ** as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-in-cell-E5.png)<figcaption>Result in cell E5</figcaption>

- Finally, you have to  **press Ctrl+D Key**  to get the value in the entire absent column.

![](https://geekexcel.com/wp-content/uploads/2021/10/Final-Output-6.png)<figcaption>Output</figcaption>

## Verdict

In this tutorial, we explained the  **formulas for basic error trapping** in Excel Office 365. Hope that this tutorial is useful to you. Mention your  **queries**  in the  **comment**  box below. Click here to know more about **[Geek Excel](https://geekexcel.com/)!! **And [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! ** Thank you so much for visiting!!

**Read Also:**

- **[How to Select Cells with Error Values in Excel Office 365?](https://geekexcel.com/how-to-select-cells-with-error-values-in-excel-office-365/)**
- **[Excel Formulas to Find the First Error Using MATCH function!!](https://geekexcel.com/excel-formulas-find-position-first-error-match/)**
- **[Formulas to Find the First Column Number in a Range ~ Easily!!](https://geekexcel.com/excel-formulas-to-find-the-first-column-number-in-a-range/)**
- **[Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-to-hide-the-n-a-error-with-vlookup-function/)**
- **[Excel Formulas to Count table columns in Excel 365!!](https://geekexcel.com/excel-formulas-to-count-table-columns-in-excel-365/)**