Earlier, we have learned the formulas to Excel Formulas to use the basic inventory formula. 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
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 **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.
- To catch errors that a formula might encounter in a worksheet, you need to use the below given formula in the formula bar.
=IFERROR(C5/D5,"")
- Now, you need to Hit the Enter key to get the *result * as shown below.
- Finally, you have to press Ctrl+D Key to get the value in the entire absent column.
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!! **And Excel Formulas *!! ** Thank you so much for visiting!!
Read Also:
Top comments (0)