CODEWITHSUNDEEP
excelexcel-formula
kit99
kit99

Reputation: 187

Excel formula IF, AND, OR - problems

Got two formules working ok separately:

=IF(AND(G47<>"*ansatt",N47="AK",(OR(W47>=3000,X47>=10000,Z47>=10000,AC47>=100000,AA47>=100000,AD47>=30000))),"Yes","No")

and

=IF(AND(G47="*ansatt",N47="AK",(OR(W47>=1,X47>=1,Z47>=1,AC47>=1,AA47>=1,AD47>=1))),"Yes","No")

I want to combine these two into one formula. Been trying for hours, but I can't figure it out. Excel message is "there is a problem with this formula".

Here's one of my attempts, adding new "OR" up front:

=IF(**OR**(AND(G47<>"*ansatt",N47="AK",(OR(W47>=3000,X47>=10000,Z47>=10000,AC47>=100000,AA47>=100000,AD47>=30000)))**AND(G47="*ansatt",N47="AK",(OR(W47>=1,X47>=1,Z47>=1,AC47>=1,AA47>=1,AD47>=1))))**,"Yes","No")

Anyone that can help me out?

Upvotes: 1

Views: 113

Answers (1)

player0
player0

Reputation: 1

=IF(OR(AND(G47<>"*ansatt",
           N47="AK", 
           OR(W47  >=3000,
              X47  >=10000,
              Z47  >=10000,
              AC47 >=100000,
              AA47 >=100000,
              AD47 >=30000)),
       AND(G47="*ansatt",
           N47="AK",
           OR(W47  >=1,
              X47  >=1,
              Z47  >=1,
              AC47 >=1,
              AA47 >=1,
              AD47 >=1))), "Yes", "No")

0

Upvotes: 1

Related Questions