Data Smell Dirty? More Tips On ISERROR With IF In Excel


If you're like me, you have to deal with spreadsheets all the time that...

  1. Someone else created,
  2. Has dirty, unorganized, mixed-up data all over the place, and
  3. You have no other data source to get what you need.

What to do?  Here's another instance where using ISERROR with IF can help you "flag" trouble spots for data cleaning.

Let's take the same data set as yesterday, two columns that we want to divide.  In this case, however, there are some pesky text cells mixed in that are cramping our style.

We can "flag" those rows for cleaning with the formula,

=IF(ISERROR(N7/O7),"NEEDS CLEANING",N7/O7)

Now you can sort by the third row and have everything needing cleaning in a nice, manageable chunk of data!

Need additional help with ISERROR, IF, or other Excel elements?  Reach out today via live chat, email, or phone!