AnsweredAssumed Answered

IF AND OR Statement - Arcade

Question asked by dafiter Champion on Aug 4, 2020
Latest reply on Aug 5, 2020 by dafiter

I can write what I am trying to do in excel but not in Arcade.

 

I am looking for a way to write something like this:

I have an IF statement followed by an AND with a bunch of OR statements. 

 

=IF(AND(OR(K4=1,K4=4),OR(L4=2,L4=1),OR(M4=2,M4=1),OR(N4=1,N4=4),OR(O4=2,O4=1),OR(P4=2,P4=1)),"0",IF(AND(OR(K4=2,K4=3,K4=5),L4=3,M4=3),"250","150"))'

Outcomes