Hello. I am trying to do a nested IF statement returning a different value if criteria is met. When I use one value to find, it works fine.
=IF(FIND("NET A", A2)=1, "NET ASSETS", "")
If I try adding additional criteria, it results in an error.
=IF(FIND("NET A", A2)=1, "NET ASSETS", ""...