IF/AND OR statement

[cbTexas]

I am not used to using an IF statement but have a spreadsheet like below. What I need is to have a formula that calculates if either the lot holder or the co lot holder are 55+ in column J and puts a 1 in the column if true and 0 if not. Then in column K, if column J is 0, it needs to put a 1 if either the lot holder or the co lot holder is under 55. Otherwise I need a 0 in the column.

Please give me a formula not a program if possible.

Thanks.

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	LOT	Lot Holder Name	Lot Holder DOB	Co Lot Holder Name	Co Lot Holder DOB	Signature	Lot Holder 55+	Co Lot Holder 55+		55+	Under 55
2	1	John Wayne	1/1/1940	Mary Jane Wayne	5/31/1975		82	47		1	1
3	2	Bill Wallace	5/3/1981				41			0	1
4	3	Frank Thomas	9/9/1976	Linda Thomas	6/4/1960		46	62		1	1
5	4	Henry Ford	7/4/1969	Heather Ford	12/25/1959		53	63		1	1
Sheet4

Cell Formulas
Range	Formula
J2:J5	J2	=IF(MAX(G2:H2)>=55,1,0)
K2:K5	K2	=IF(MIN(G2:H2)<55,1,0)