Forum Discussion
GlintF
Sep 27, 2024Copper Contributor
Getting an error when using nested IF function
I'm trying to sort through a column of remarks. If any of the remarks contain one word, I need to pull that word out. If it says a different word, I need to pull that one out. No remark should have b...
- Sep 27, 2024The problem is that FIND() will return #VALUE! if not found. So enclose that in ISNUMBER() or IFERROR( ... , 0) like:
=IF(ISNUMBER(FIND("FWA",DATA!AM7)), "FWA", IF( ISNUMBER(FIND("JBER",DATA!AM7)),"JBER",""))
and I added a "" if not found
m_tarler
Steel Contributor
The problem is that FIND() will return #VALUE! if not found. So enclose that in ISNUMBER() or IFERROR( ... , 0) like:
=IF(ISNUMBER(FIND("FWA",DATA!AM7)), "FWA", IF( ISNUMBER(FIND("JBER",DATA!AM7)),"JBER",""))
and I added a "" if not found
=IF(ISNUMBER(FIND("FWA",DATA!AM7)), "FWA", IF( ISNUMBER(FIND("JBER",DATA!AM7)),"JBER",""))
and I added a "" if not found
GlintF
Sep 27, 2024Copper Contributor
Oh, duh. Thank you, I should have realized that. I appreciate it.