Forum Discussion

Peta Stolle's avatar
Peta Stolle
Copper Contributor
Sep 28, 2017

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_Lewin's avatar
    Detlef_Lewin
    Silver 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.

     

Resources