Writing an IF FORMULA with conditions

[Tripleseas]

Hello community,

i have 3 columns in excel

column 1	column2	column3
12222	(blank)	NOT OK
YES	(blank)	OK
YES	double	NOT OK
13444	double	NOT OK

the first column contains numbers and a text " YES"
the second colum contains empty cells(blank) and a text " Double"

i want to write an IF formula in column 3 that can show either "ok" or "not ok" depending on all 4 conditions.
if column 1 is showing numbers and column 2 is empty then not ok , and if column 1 contains YES and column 2 is empty then OK , and if column 1 is YES and column 2 is double then not ok and finnaly if column 1 is numbers and column 2 is double then not ok.

hope that i'm clear. thanks all

 

[igold]

How about this...

Book1
	A	B	C
1	12222		NOT OK
2	YES		OK
3	YES	double	NOT OK
4	13444	double	NOT OK
5
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(AND(A1="YES",B1=""),"OK","NOT OK")

 

[Tripleseas]

How about this...

Book1
	A	B	C
1	12222		NOT OK
2	YES		OK
3	YES	double	NOT OK
4	13444	double	NOT OK
5
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=IF(AND(A1="YES",B1=""),"OK","NOT OK")

Thank you that will do it. working great !

 

[igold]

You're welcome., I was happy to help. Thanks for the feedback.