If statement error

[mapratt82]

I'm try to mark the records with the following class codes for the account type. I created the following IF Statement to do it, but says Error in expression, and I have no clue. Help Please!

if ({<Account_Type_Description = {SAV},Class_Code = {41}>},'Yes',

if ({<Account_Type_Description = {DDA},Class_Code = {51,52,53,54}>},'Yes',

if ({<Account_Type_Description = {COD},Class_Code = {51}>},'Yes','No')))

Thanks

[sunny_talwar]

May be this:

If(

(Account_Type_Description = 'SAV' and Class_Code = 41) or

(Account_Type_Description = 'DDA' and Match(Class_Code, 51, 52, 53, 54)) or

(Account_Type_Description = 'COD' and Class_Code = 51),

'Yes',

'No')