Error Catching: Using ISERROR With IF In Excel


The great baseball catcher, coach, and philosopher Yogi Berra once said, "We made too many wrong mistakes."  You can be a mistake catcher too, brave Excel user!

More precisely, you can be an error catcher.  Let's say you wanted to divide the numbers in one column by the numbers in another column.  But look what happens when you divide by zero!  AN ERROR!

We can catch this sort of thing and make the cell return something else with a conditional statement (IF) and the ISERROR function.

=IF(ISERROR(N7/O7),0,N7/O7)

In English, this formula basically says "If dividing N7 by O7 results in an error, just return zero; otherwise, go ahead and divide N7 by O7."

Need additional help with IF, ISERROR, or other Excel elements?  Reach out today by live chat, email, or phone to our friendly team of Sherpas!