IFERROR Formula in Excel || How to handle error result
The Excel IFERROR function returns a custom result when a formula generates an error and a standard result when no error is detected.
IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
Syntax
=IFERROR (value, value_if_error)
============================================================
Sharing is caring !!! Your responses will inspire me to upload more tutorial.💪💪
So...Share 🤝 || Like 👍 || Comment ✍️
👉 Our all youtube video:- https://www.youtube.com/c/mmbcampus?s...
👉 Excel VBA all video:- • How to use "IF, ElseIf, Else" in Excel VBA...
👉 Excel Formula all video:- • How to write Microsoft Excel Formula, Part...
👉 Ask your any question in facebook page / mmbcampus2016
👉 Visit https://www.mmbcampus.com to download all related file, if any.
===========================================================
Link you may like:
How to convert a text into number with VALUE formula in Excel
• How to convert a text into number with VAL...
All pros and cons of IF formula of Excel in only 10 minutes with many examples. • All pros and cons of IF formula of Excel i...
IFS formula in Excel (Replacement of Nested IF; RIP IF 😔) || Part-01, Basic discussion with example.
• IFS formula in Excel (Replacement of Neste...
VlookUp formula (Exact matching) in Excel (Part-01) || All details with Limitation & solution • VlookUp formula (Exact matching) in Excel ...
All method of Formula dragging, copy & paste; Uses of $ sign in Formula of Excel
• All method of Formula dragging, copy & pas...