If statement with virtual column and adding additional condition

[jfong12]

Hi Again! I had my initial question answered but I ran into another roadblock, hopefully, this is an easy fix as I am still learning App Sheet and haven't had a solution work just yet. So with the formula listed below it works but I want to include another business unit 'Logistics'. I have tried using the "AND", "OR", and "IN" functions but they haven't worked. I want it to say 'yes' if either business unit equals inspection center or logistics and if a work location matches the list provided. 

Please note this is a virtual column!

IF(
AND([Business Unit]="Inspection Centers",
IN([Work Location],LIST(
'AL',
'AR',
'AZ',
'CA',
'FL',
'IL',
'IN',
'NC',
'NJ',
'OH',
'OH',
'OH',
'OK',
'TN',
'TX',
'UT',
'VA'))),"Yes","No")

[dbaum · Accepted solution]

AND(
  IN([Business Unit], LIST("Inspection Centers", "Logistics")),
  IN([Location], LIST("AL, "AR", ...))
)

[jfong12]

Thank you @dbaum! Wow, I feel silly! I was putting the parenthesis at the very end instead of right after the list for the business unit ....... excuse me as I facepalm haha