IF statement with multiple conditions check

[NitiGupta]

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

N1.123

E1.162

N1.275

N1.404

N1.383

N1.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 solution]

Endif 

just add that to the end of your if statement. 

so close!

mark

[NitiGupta]

Oh yes.. haha. Thanks for that.