Forum Discussion

AL789's avatar
AL789
Copper Contributor
Dec 18, 2019
Solved

Help: IF statement with Multiple AND , OR conditions

Hi everyone,   I need some help writing an IF statement that includes multiple AND and OR conditions. See the sample file attached. I want to write an IF statement that will meet all of the conditi...
excel
Formulas and Functions
office 365
  • Twifoo's avatar
    Twifoo
    Dec 18, 2019

    AL789 

    I tried to reduce the logic and this is what my formula looks like in D2 of the attached file: 

AL789's avatar
AL789
Copper Contributor
Dec 18, 2019
Thank you. This worked perfectly for what I am trying to achieve.
Twifoo's avatar
Twifoo
Silver Contributor
Dec 18, 2019
You’re perfectly welcome!

Resources