IFERROR funtion

We often tend to encounter instances while using formulae performing day to day operations where the formulae results in an error. Often, some basic users prefer manually correcting those errors and so advance users go one step ahead using a combination of "IF" & "ISERROR" functions. Even I'm one of those users who prefer using the "IF" & "ISERROR" combination until I came across the "IFERROR" function.

Syntax: IFERROR(value,value_if_error)


According to Microsoft, "IFERROR" evaluates  #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! type of errors.

Say: Cell A1 contains a numeric value and Cell A2 contains 0 as value. You intend to perform a simple operation A1 divided by A2 (=A1/A2). In our example, the result would be #DIV/0!. Now, lets redo this simple division using "IFERROR" function. The formula can be written as "=IFERROR(A1/A2,0)" wherein the formula would asses that if the result of A1/A2 is an error the formula should put in 0 instead of the error.

This is indeed very helpful function which can be used with ease to perform various operations in an Excel sheet.

Comments

  1. If might have} any 카지노사이트 questions concerning the supply or should you experience technical points in receiving the Bonus, please contact our help employees at Spin away on top slots like Zeus III, Elvis The King Lives, Montezuma, Pirates Millions, Ultimate Universe and Panda Manga. Cale Makar says the early portion of Avalanche schedule is “ridiculous.” Here’s how it’s showing. Any on line casino they regulate is secure and safe so that you can} play at.

    ReplyDelete

Post a Comment

Popular posts from this blog

Keyboard Shortcut to add/delete rows or columns in Excel

Excel Keyboard Shortcuts - Handy during day to day work

Alternative for SUMIF and SUMIFS - Part 2 (SUMPRODUCT)