IF AND OR Statement - Arcade

2902
11
Jump to solution
08-04-2020 03:21 PM
RickeyFight
MVP Regular Contributor

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"))'
0 Kudos
11 Replies
KenBuja
MVP Esteemed Contributor

Then you'd have to use this syntax

$feature.sveg_z1=="2" || $feature.sveg_z1=="1"
RickeyFight
MVP Regular Contributor

Ken Buja

Yep that did it!  Thanks! 

0 Kudos