IF With Multiple Crietria

[kumara_faith]

HI,

I have the following table:

Excel Workbook
	B	C	D
10	CODE	TYPE	RESULTS
11	DC	Police	Police
12	DC	Police	Police
13	DC	#N/A	ERROR
14	DC	#N/A	ERROR
15	STANDARD	#N/A	STANDARD
Sheet1

I am trying to have the Results column as follows:

1) If the Code is not "Standard" and there is a word in column "Type", the Results should be the value in the column "Type"
2) If the Code is "Standard" and there is #N/A in column "Type", then the Results should be "Standard"
3) If the Code is not "Standard" and there is #N/A in column "Type", the the Results should be "Error"

I am trying with this formula but did not quite get there.

=IF(AND(ISNA(C3),B3="STANDARD"),"STANDARD","ERROR")

Appreciate all the help.

 

[Aladin Akyurek]

In C11 enter and copy down:

=IF(ISNA(B11),IF(A11="STANDARD","STANDARD","ERROR"),B11)

 

[Joe4]

What is Code is "Standard", but the Type is not #N/A?
Then what happens?

 

[Nine Zero]

Try this out on D11 and fill down

=IF(AND(B11="STANDARD",ISERROR(C11)),"STANDARD",IF(AND(NOT(B11="STANDARD"),ISERROR(C11)),"ERROR",C11))

Edit: Like Joe4 pointed out there are some situations that havent been covered, the above covers only what you stated

 

[Joyner]

Hello, If I understand correct, maybe:

=IFERROR(IF(AND(ISNA(C3),B3="STANDARD"),"STANDARD","C3"),"ERROR")

Same question as Joe4, but I assumed return C3

 

[Aladin Akyurek]

In C11 enter and copy down:

=IF(ISNA(B11),IF(A11="STANDARD","STANDARD","ERROR"),B11)

In D11 enter and copy down:

=IF(ISNA(C11),IF(B11="STANDARD","STANDARD","ERROR"),C11)

 

[Joyner]

Hello, If I understand correct, maybe:

=IFERROR(IF(AND(ISNA(C3),B3="STANDARD"),"STANDARD","C3"),"ERROR")

Same question as Joe4, but I assumed return C3

OOPS quotes around my C3 reference, should be:

=IFERROR(IF(AND(ISNA(C3),B3="STANDARD"),"STANDARD",C3),"ERROR")