Formula Help

jalizmaldonado

Hi, I'm receiving an "unmatched" error on my formula at the "then" piece:

IF (Contains([COMBREG INPUT], "Vacation Accrue") OR (Contains([COMBREG INPUT], "Vac Accrue") && Contains ([G/L CATEGORIES (CR)],"60600 Salaries & Benefits : Vacation expense"))
THEN '22350 Accrued Vacation'
else
[G/L CATEGORIES (CR)]
endif

--

I'm assuming I'm missing parentheses around something but every time I add or take away, I keep getting an error. I'm trying to account for:

1. Vacation Accrue

2. Vac Accrue

3. Vac $ Accrue

Is there anyone available to look over my formula? 

Never ever.PNG

CharlieS

Looks like you need one more close parenthesis:

IF (Contains([COMBREG INPUT], "Vacation Accrue") OR (Contains([COMBREG INPUT], "Vac Accrue") && Contains ([G/L CATEGORIES (CR)],"60600 Salaries & Benefits : Vacation expense")))
THEN '22350 Accrued Vacation'
else
[G/L CATEGORIES (CR)]
endif

In cases of nested logic like this, I like to line out the expression like this to help keep track of the logical steps (and syntax):

IF (
Contains([COMBREG INPUT], "Vacation Accrue")
OR (
Contains([COMBREG INPUT], "Vac Accrue")
&& Contains ([G/L CATEGORIES (CR)],"60600 Salaries & Benefits : Vacation expense")
)
)
THEN '22350 Accrued Vacation'
else
[G/L CATEGORIES (CR)]
endif