Forum Discussion
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 ...
Peta,
the formula could be:
=OR(G2={"x";"y";"z"})*(H2="")*(I2<>"")*A2The last part of your question is not clear to me.