please help me with the if statement.

[#1]

How can I put these 2 if statements in 1 if statement.

  if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust_Reccuring') as FEETYPE

  if(ActualAccount <>0,'Trust Reccuring') as FEETYPE

Thanks in advance.

[#2]

Like this?

if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring',if(ActualAccount <>0,'Trust Reccuring') ) as FEETYPE

[rwunderlich]

What's the value supposed to be if CATEGORY=4 and ActualAccount=0?

-Rob

[maxgro]

not fully understand the logic of your inquiry, however you can combine and, or, and nested if, for example,

=

if(match(CATEGORY,'4','9','16','21','22')=0 or ActualAccount=0, 'Trust_Non-Reccuring',

if(match(CATEGORY,'4','9','16','21','22')=1 or ActualAccount <>0, 'Trust_Reccuring',

'???'))