Nested IF statement multiple OR

[cmaraffi]

Hi, I am trying to figure out what I am doing wrong here. Please help. Is there a better way to update multiple criteria with the four buckets?

[ChrisTX]

This is also a syntax error:

You can use an IN   

or you have to repeat the [Account ID] = 

A good place to get up to speed is under Learn > Academy > Learning Paths

Chris

[apathetichell]

One more quick thing as presently constructed your if/then/else couldn't work because you are comparing one value against two different types of  of clauses. I don't know what type of variable your fields are but you cannot compare something to a number and to a string. That is an error.

You can have if [myfield] ="5" or [myfield6]= "a" but you can't have if [myfield]=5 or [myfield]= "a"

[Lili1]

Super helpful, thank you!