Help Using Contain Function for multiple criteria

[sehgaln]

I am trying to use the contain function, but I have multiple criteria that I need to check for. 

An example is: If AA = '85' and MAC = '813' and USSGL = 488100 or 498100 then 0709. 

Is the expression below correct? Looks like the OR statement is throwing my output off. 

IF [AA] = "85" AND [MainAccountCode] = "813" AND Contains([USSGL], "488100") OR
Contains([USSGL], "498100")
THEN '0709'

[Kenda · Accepted solution]

@sehgaln Put parenthesis around your or portion.

Also don't forget your else and endif parts of the formula.

Lastly, your fields will all have to be strings for your formula to work.

Here are those modifications I made to your formula:

IF [AA] = "85" AND [MainAccountCode] = "813" AND (Contains([USSGL],"488100") OR
Contains([USSGL], "498100"))
THEN '0709' ELSE null() ENDIF

[sehgaln]

I checked all of that and it's still not populating correctly 

[BenMoss]

Can you please post your amended formula and also some sample data so we can test this.

Ben

[BenMoss]

The formula posted by @Kenda seems to function perfectly.

See the attached example.