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? 

[CharlieS · Accepted solution]

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

[Qiu · Accepted solution]

@jalizmaldonado 
As you assumed, the parenthesis is causing the issue here.

It would be better if they have something highlighted pair of parenthesis as in Excel.

[jalizmaldonado]

Thank you so much!

[jalizmaldonado]

I really appreciate it. Thank you so much. 

[Qiu]

@jalizmaldonado 
Glad to help and thank you for the accept mark 😁