Forum Discussion

Copper Contributor

Apr 10, 2018

Solved

Help w/ Nested ISERROR Function

I need some help figuring out why this formula is not working. I am using Office 2013 and it is an xlsx file. This is a simplified version of the formula that I am trying to use. In A1 I have =...

Formulas & Functions

Need Help

Haytham Amairah
Apr 10, 2018
Hi,

For the purpose of alert, the error always takes on the result of the formula if it appears in any part of the formula!

You have to rebuild that formula as follows to catch the error from the beginning:
=IFERROR(IF(A1="","","Test"),"")
Regards

Haytham Amairah

Silver Contributor

Apr 10, 2018

Hi,

For the purpose of alert, the error always takes on the result of the formula if it appears in any part of the formula!

You have to rebuild that formula as follows to catch the error from the beginning:

=IFERROR(IF(A1="","","Test"),"")

Regards

T E
Copper Contributor
Apr 10, 2018
Thank you SO much! It took me a little bit but I was able to apply the structure of the formula you provided to my spreadsheet and it works!

The trick for me was to create the parts of the formula that work properly and paste that into the 'value' portion of the IFERROR function.

Many thanks for your help! :)