Creating a new field using multiple if statements in data load editor

[rubenacampos]

I'm trying to create a new field when my data loads based on multiple conditions.  The following fields are loaded with the data load editor:

[Procurement Type]

[Primary Contract Type]

[Procurement Action]

From these fields I would like to create a new field called "COR Type" based on multiple criteria found within the fields above using an IF Statement:

if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='Firm Fixed Price' or 'Order Dependent') and ([Procurement Action]<>'*MOD*'),'Type A',
if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]<>'Firm Fixed Price' or 'Order Dependent' or '*Cost*') and ([Procurement Action]<>'*MOD*'),'Type B',
if(([Procurement Type]='SERVICES' or 'A&E' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='*Cost*') and ([Procurement Action]<>'*MOD*'),'Type C'))) AS "COR Type"

The new "COR Type" field is created but the results only show Type A and Type B when the [Procurement Type] = Services.  All the other [Procurement Type] are not evaluated nor is the [Primary Contract Type] and [Procurement Action] evaluated.  Thank you in advance for your assistance! 

[rubenacampos]

[Procurement Type]

[Primary Contract Type]

[Procurement Action]

From these fields I would like to create a new field called "COR Type" based on multiple criteria found within the fields above using an IF Statement:

if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='Firm Fixed Price' or 'Order Dependent') and ([Procurement Action]<>'*MOD*'),'Type A',
if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]<>'Firm Fixed Price' or 'Order Dependent' or '*Cost*') and ([Procurement Action]<>'*MOD*'),'Type B',
if(([Procurement Type]='SERVICES' or 'A&E' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='*Cost*') and ([Procurement Action]<>'*MOD*'),'Type C'))) AS "COR Type"

The new "COR Type" field is created but the results only show Type A and Type B when the [Procurement Type] = Services.  All the other [Procurement Type] are not evaluated nor is the [Primary Contract Type] and [Procurement Action] evaluated.  Thank you in advance for your assistance! 

[Yoshidaqlik · Accepted solution]

Hi

fine?

try:

if(
	Wildmatch([Procurement Type],'SERVICES','R&D','CONSTRUCTION')>0 and 
	Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent')>0 and 
	Wildmatch([Procurement Action],'*MOD*')=0,
	'Type A',
	
	if(
		Wildmatch([Procurement Type]='SERVICES','R&D','CONSTRUCTION')>0 and 
		Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent','*Cost*')=0 and 
		Wildmatch([Procurement Action],'*MOD*')=0,
		'Type B',
		if(
			Wildmatch([Procurement Type],'SERVICES','A&E','R&D','CONSTRUCTION')>0 and 
			Wildmatch([Primary Contract Type],'*Cost*')>0 and 
			Wildmatch([Procurement Action],'*MOD*')=0,
			'Type C'
		)
	)
) AS "COR Type"

Regards

[rubenacampos]

THANK YOU, it worked!