"Number of opened and closed parentheses does not match" Incorrect

[anonymous]

Hi Guys,
Whats wrong with the below expression?

AND(OR(IN(LOOKUP(USEREMAIL(), Staff, Email, Title), LIST("Payroll","Manager")), 
LOOKUP(USEREMAIL(), "Staff", "Email", "FilterFrom")<=[Start Time]),
LOOKUP(USEREMAIL(), "Staff", "Email", "FilterTo")<=[Finish Time]),
LOOKUP(USEREMAIL(), "Staff", "Email", "FilterProject")=[Project]),
LOOKUP(USEREMAIL(), "Staff", "Email", "FilterTask")=[Task])

I get the following error, even though it is not the case. It works if I remove the bottom 2 rows…

[HBT]

DECIDE WHERE THE “OR” STATUS ENDS.

AND(
OR(
IN( LOOKUP(USEREMAIL(), Staff, Email, Title), LIST(“Payroll”,“Manager”)
),
LOOKUP(USEREMAIL(), “Staff”, “Email”, “FilterFrom”)<=[Start Time]
), --------- OR IS ENDING HERE. IF OR DOES NOT END HERE SIGN MUCH PARENTHESES.
LOOKUP(USEREMAIL(), “Staff”, “Email”, “FilterTo”)<=[Finish Time]
), --------- OR IS ENDING HERE. IF OR DOES NOT END HERE SIGN MUCH PARENTHESES.
LOOKUP(USEREMAIL(), “Staff”, “Email”, “FilterProject”)=[Project]
),
LOOKUP(USEREMAIL(), “Staff”, “Email”, “FilterTask”)=[Task]
)

DECIDE WHERE THE “OR” STATUS ENDS.

If it ends in the second case, your expression should be::

AND(
   OR(
         IN( 
             LOOKUP(USEREMAIL(), Staff, Email, Title), LIST("Payroll","Manager")
           ),
           LOOKUP(USEREMAIL(), "Staff", "Email", "FilterFrom")<=[Start Time] 
      ),
     LOOKUP(USEREMAIL(), "Staff", "Email", "FilterTo")<=[Finish Time],
     LOOKUP(USEREMAIL(), "Staff", "Email", "FilterProject")=[Project],
     LOOKUP(USEREMAIL(), "Staff", "Email", "FilterTask")=[Task]
)

[anonymous]

Thankyou!