# IFERROR

## “IFERROR”

Used for – “IFERROR” function in MS Excel is used to performs a specified task in case formula you typed have tendency to ends up or results as error..

Syntax – IFERROR(value, value_if_Error).
Value –The value is any formula/reference cell, you typed or calculated which may results error at any instant with any set of data.
Value_if_Error – This is the value you want see as a result when your said value results a error. It can be a number/text/formula.

Example – Following example will clear the IFERROR function:-
 A B C D E F G H I 1 a =A1*A1 =IFERROR(B1,”CHECK”) =IFERROR(A1*A1,0) =IFERROR(A1*A1,A2*A2) 2 2 =A2*A2 =IFERROR(B2,”CHECK”) =IFERROR(A2*A2,0) 3 4 5 6 7

And result you get as under:-
 A B C D E F G H I 1 a #VALUE! CHECK 0 4 2 2 4 4 4 3 4 5 6 7

Note:- The IFERROR Function can be used to tell excel which operations is to be done or which result to be shown if the result you got after calculation is ends up with error.

Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.