Get instant live expert help on iserror in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello. I am having issues with the ISERROR function
Solved by B. A. in 16 mins
Solved by A. H. in 14 mins
=IF(ISERROR(CI48/CI5),"-",(CI48/CI5)) what is this formula calculating? is it making CI48/CI5 negative?
Solved by A. J. in 26 mins
I want to compare 2 columns with this formula = IF (ISERROR (MATCH (A1, $ C $ 1: $ C $ 5.0)), "", A1)
Solved by G. J. in 21 mins
Subject: Search for text within a range of cells in Excel using an IF statement Body: Right now I have a working formula to search for 2 non-printing characters in a single cell, but I need to search multiple cells on the same row. What is working: =IF(NOT(ISERROR(SEARCH(" ",$H2))),"Non-printing character",IF(NOT(ISERROR(SEARCH(" ",$H2))),"Non-printing character","OK")) What I want to do is search $H2:$Q2 and if a non-printing character is contained anywhere within $H2:$Q2, I want cell G2 to display "Non-printing character." If a non-printing character is not found, I want G2 to display "OK." Any ideas?
Solved by V. Q. in 20 mins