Forum Discussion
Peta Stolle
Sep 28, 2017Copper Contributor
Nested If function with multiple criteria
Hi, i have a list that I am trying to use an if function on another tab to only bring across certain lines. I'm trying to get. For example if cell G2 says X,y or z and H2 is blank and i2 is not blank then put value A2. But I can't seem to get my formula to work for the G2 criteria. It work fine separately. Also how do I get it so that when I copy it down that it will not show false lines and put the true results one after each other. Thank you.
- Detlef_LewinSilver Contributor
Peta,
the formula could be:
=OR(G2={"x";"y";"z"})*(H2="")*(I2<>"")*A2
The last part of your question is not clear to me.