“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.
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.