How do I use the "IN" statement in a script

[bsnoles]

I currently have a routine in a dimension field that says the following:

=IF(([CCaR Budget FMS Country Code] = 'A3' OR ([CCaR Budget FMS Country Code] = '7B' OR and this goes on forever until I get to the end and the routine says ... 'Update Record', NULL())

How do I use an IN statement to avoid having to retype ([CCaR Budget FMS Country Code] = .....

[Saravanan_Desingh · Accepted solution]

Try this

=IF(WildMatch([CCaR Budget FMS Country Code],'A3','7B','XYZ'),'Update Record', NULL())

[bsnoles]

Thank you, this worked perfect....

[aniaqueen232]

A catch can in a car is a modification often employed by automotive enthusiasts to enhance engine performance and reduce carbon deposits. It is especially popular in high-performance and turbocharged vehicles.