IF statement with multiple conditions check

Question

I am trying to perform something like this instead of writing each case individually

N1.123E1.162N1.275N1.404N1.383N1.460

if [Project No] in (
'N1.123',
'E1.162',
'N1.275',
'N1.404',
'N1.383',
'N1.460') then '1' else '0'

but it doesn't work. What should be the right way.

MarqueeCrew · Accepted Answer

Endif

just add that to the end of your if statement.

so close!

mark