Iferror

Description of formula:
Checks if given formula returns an error. If not, returns result of its action. If yes, it returns replacement value. (Type of parameters must be the same as type of result.)
Error examples:
=sqrt(-4)
=date(2011,03,43)
=left(text,-2)
=nth(A1:A3,5)
Syntax:
iferror(value,replacement)
Parameters:
value
(type: any) value, which function has to checked
replacement
(type: any) value, which you want instead of error
Returned type:
Any
Examples:
=iferror(nth(A1:A3,5),'wrong_value')
=iferror(B2,0)
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk