How to handle Excel Formula errors

IFERROR function is the best solution to handle this kind or formula errors


Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula.


IFERROR(value, value_if_error)

Syntax arguments:

Required. The argument that is checked for an error.
Required. The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

for example any where appear the error in cell just use the IFERROR before start of formula or function and last type the result you want to be appear instead of error
using with divided formula

using with VLOOKUP() function

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...