If then Statement in excel using data in 2-3 columns

brendajean 0 Newbie Poster

14 Years Ago

I am trying to create an If Then statement to use in an excel spreadsheet using data from 2 or 3 columns.
Column AB has text. Column AA has a date in it. I need the statement to say if column AB says RFEP or TRFE and Column AA is greater than 08/01/07, the true value is "Y" and the false value is "N".
=IF((AA2>08/01/07)+(AB2="RFEP"),"Yes","No") This is only picking up the date in AA2. I tried the & for a connector and got “value” only.
As you can see, I haven't even tried to add the TRFE information.

I would also like to add column X to the mix. If column X has a "Y" in it, it would also be included in the true value of "Y". However, I would be very happy with just the first two items.
Thank you for the help.

visual-basic-6

sample_data_for_formula.txt (33.66 KB)

The attachment preview is chopped off after the first 10 KB. Please download the entire file.

StudentID	FirstName(required)	LastName(required)	Address	City	State	ZipCode	HomePhone	"Gender(required, M or F)"	Ethnicity?(Lookup)	Language?(Lookup)	BirthDate	sais	ParentNames	Grade(required)	Special Ed?(Y/N)	Enter Date	Leave Date	Enter Code	Leave Code	HR Last	HR First	School Name	English Language Learner?(Y/N)	ELLIADate	ELLIAResult	ELLRADate	ELLRAResult	formula
																							N	9/20/02	NELL	4/22/08	CELL	Yes
																							N	10/15/03	NELL	4/30/08	CELL	Yes
																							N	10/1/04	NELL	3/30/09	CELL	Yes
																							N	10/10/03	NELL	4/3/09	CELL	Yes
																							N	8/31/01		10/4/02	CFEP	Yes
																							N	9/12/01		11/4/03	CFEP	Yes
																							N	9/7/00		12/2/03	CFEP	Yes
																							N	5/27/03		4/27/04	CFEP	Yes
																							N	9/14/01		10/2/02	RFEP	Yes
																							N	9/17/01		10/11/04	RFEP	
																							N	8/27/01		11/4/04	RFEP	
																							N	9/13/02		11/29/04	RFEP	
																							N	9/10/02		11/29/04	RFEP	
																							N	9/18/02		12/2/04	RFEP	
																							N	9/19/03		12/2/04	RFEP	
																							N	9/6/01		1/3/05	RFEP
																							N	9/4/02		1/6/05	RFEP
																							N	9/12/01		1/7/05	RFEP
																							N	2/13/02		2/3/05	RFEP
																							N	1/29/02		2/3/05	RFEP
																							N	2/4/03		2/9/05	RFEP
																							N	2/4/03		2/15/05	RFEP
																							N	9/26/01		2/16/05	RFEP
																							N	9/19/02		3/3/05	RFEP
																							N	9/5/01		3/3/05	RFEP
																							N	8/30/02		3/3/05	RFEP
																							N	9/13/01		3/3/05	RFEP
																							N	9/11/02		3/7/05	RFEP
																							N	9/9/02		3/16/05	RFEP
																							N	8/25/00		3/17/05	RFEP
																							N	9/5/01		3/17/05	RFEP
																							N	9/10/01		3/17/05	RFEP
																							N	9/29/03		4/4/05	RFEP
																							N	9/12/02		4/6/05	RFEP
																							N			4/11/05	RFEP
																							N	9/17/03		4/14/05	RFEP
																							N	8/31/01		5/2/05	RFEP
																							N	9/3/04	NELL	10/26/05	RFEP
																							N	8/27/03		11/2/05	RFEP
																							N	9/10/02		11/21/05	RFEP
																							N	4/8/02		2/6/06	RFEP
																							N	5/5/05	TCEL	2/6/06	RFEP
																							N	9/29/03	NELL	2/6/06	RFEP
																							N	9/27/04	NELL	2/7/06	RFEP
																							N	8/21/03		2/7/06	RFEP
																							N	9/4/02		2/8/06	RFEP
																							N	9/27/04	NELL	2/8/06	RFEP
																							N	9/26/02		2/8/06	RFEP
																							N	9/12/01		2/8/06	RFEP
																							N	9/7/01		2/8/06	RFEP
																							N	9/3/04	TCEL	2/8/06	RFEP
																							N	11/4/04	NELL	2/8/06	RFEP
																							N	9/24/04	NELL	2/9/06	RFEP
																							N	9/22/03		2/9/06	RFEP
																							N	9/3/03		2/9/06	RFEP
																							N	10/30/03		2/9/06	RFEP
																							N	9/12/02		2/9/06	RFEP
																							N	8/31/00		2/9/06	RFEP
																							N	9/11/01		2/9/06	RFEP
																							N	1/8/04		2/9/06	RFEP
																							N	9/30/04	NELL	2/9/06	RFEP
																							N	8/27/01		2/9/06	RFEP
																							N	10/15/01		2/9/06	RFEP
																							N	8/28/03		2/13/06	RFEP
																							N	9/3/04	NELL	2/16/06	RFEP
																							N	9/29/04	NELL	2/21/06	RFEP
																							N	9/2/03		2/21/06	RFEP
																							N	10/21/03		2/22/06	RFEP
																							N	9/17/02		3/1/06	RFEP
																							N	9/13/02		3/2/06	RFEP
																							N	9/19/02		3/2/06	RFEP
																							N	9/13/02		3/2/06	RFEP
																							N	10/27/04	CELL	3/2/06	RFEP
																							N	2/9/04		3/2/06	RFEP
																							N	9/13/02		3/7/06	RFEP
																							N	8/27/04	NELL	3/8/06	RFEP
																							N	9/13/02		3/8/06	RFEP
																							N	9/19/02		3/8/06	RFEP
																							N	3/9/05	NELL	3/8/06	RFEP
																							N	9/11/01		3/8/06	RFEP
																							N	9/16/02		3/9/06	RFEP
																							N	9/18/02		3/9/06	RFEP
																							N	1/27/03	NELL	3/13/06	RFEP
																							N	9/4/03		3/16/06	RFEP
																							N	9/16/03		3/16/06	RFEP
																							N	1/13/05	TCEL	3/16/06	RFEP
																							N	5/13/05	TCEL	3/16/06	RFEP
																							N	8/27/03		3/29/06	RFEP
																							N	10/10/00		4/18/06	RFEP
																							N	9/6/00		4/18/06	RFEP
																							N	5/1/05	TCEL	4/21/06	RFEP
																							N	5/18/05	TCEL	4/24/06	RFEP
																							N	5/10/05	TCEL	9/27/06	RFEP
																							N	9/26/05	NELL	10/16/06	RFEP
																							N	9/6/05	NELL	2/5/07	RFEP
																							N	8/31/05	NELL	2/5/07	RFEP
																							N	9/12/03	NELL	2/5/07	RFEP
																							N	9/4/02	NELL	2/5/07	RFEP
																							N	9/7/04	NELL	2/6/07	RFEP
																							N	9/2/04	NELL	2/6/07	RFEP
																							N	9/3/04	NELL	2/6/07	RFEP
																							N	9/7/04	NELL	2/6/07	RFEP
																							N	11/3/04	NELL	2/6/07	RFEP
																							N	9/13/04	NELL	2/6/07	RFEP
																							N	8/15/05	TCEL	2/6/07	RFEP
																							N	9/30/03	NELL	2/6/07	RFEP
																							N	9/24/04	NELL	2/7/07	RFEP
																							N	9/7/04	NELL	2/7/07	RFEP
																							N	9/8/03	NELL	2/8/07	RFEP
																							N	9/22/05	NELL	2/8/07	RFEP
																							N	9/12/03	NELL	2/8/07	RFEP
																							N	8/30/05	NELL	2/13/07	RFEP
																							N	9/3/04	NELL	2/13/07	RFEP
																							N	9/3/04	NELL	2/13/07	RFEP
																							N	9/15/04	NELL	2/13/07	RFEP
																							N	9/7/04	NELL	2/13/07	RFEP
																							N	9/3/04	NELL	2/13/07	RFEP
																							N	8/19/05	NELL	2/13/07	RFEP
																							N	9/7/04	NELL	2/14/07	RFEP
																							N	9/7/04	NELL	2/14/07	RFEP
																							N	9/7/04	NELL	2/15/07	RFEP
																							N	8/28/03	NELL	2/15/07	RFEP
																							N	9/22/03	NELL	2/15/07	RFEP
																							N	9/17/01	NELL	2/28/07	RFEP
																							N	10/22/01	NELL	2/28/07	RFEP
																							N	9/12/01	NELL	2/28/07	RFEP
																							N	9/13/01	NELL	3/2/07	RFEP
																							N	9/30/04	NELL	3/5/07	RFEP
																							N	9/7/00		3/5/07	RFEP
																							N	9/28/04	NELL	3/7/07	RFEP
																							N	9/2/04	NELL	3/7/07	RFEP
																							N	9/10/02	NELL	3/9/07	RFEP
																							N	9/4/02	NELL	3/9/07	RFEP
																							N	9/10/02	NELL	3/9/07	RFEP
																							N	9/13/02	NELL	3/9/07	RFEP
																							N	9/16/02	NELL	3/12/07	RFEP
																							N	9/8/03	NELL	3/13/07	RFEP
																							N	8/26/04	NELL	3/13/07	RFEP
																							N	9/17/02	NELL	3/15/07	RFEP
																							N	3/3/05	NELL	3/15/07	RFEP
																							N	9/18/02	NELL	3/15/07	RFEP
																							N	9/18/02	NELL	3/27/07	RFEP
																							N	9/19/02	NELL	3/27/07	RFEP
																							N	1/20/05	NELL	3/28/07	RFEP
																							N	8/29/05	NELL	4/3/07	RFEP
																							N	9/23/04	NELL	4/26/07	RFEP
																							N	8/30/05	NELL	2/4/08	RFEP
																							N	8/22/05	NELL	2/4/08	RFEP
																							N	8/22/05	NELL	2/4/08	RFEP
																							N	11/3/05	TCEL	2/4/08	RFEP
																							N	8/22/05	NELL	2/4/08	RFEP
																							N	8/25/05	NELL	2/5/08	RFEP
																							N	8/31/05	NELL	2/5/08	RFEP
																							N	8/22/05	NELL	2/5/08	RFEP
																							N	8/23/05	NELL	2/5/08	RFEP
																							N	9/8/05	NELL	2/5/08	RFEP
																							N	8/25/05	NELL	2/5/08	RFEP
																							N	8/1/05	TCEL	2/5/08	RFEP
																							N	8/22/05	NELL	2/5/08	RFEP
																							N	8/29/05	NELL	2/5/08	RFEP
																							N	8/23/05	NELL	2/5/08	RFEP
																							N	8/22/05	NELL	2/5/08	RFEP
																							N	9/14/05	NELL	2/5/08	RFEP
																							N	8/22/05	NELL	2/6/08	RFEP
																							N	9/8/05	NELL	2/6/08	RFEP
																							N	9/6/05	NELL	2/6/08	RFEP
																							N	8/22/05	NELL	2/6/08	RFEP
																							N	4/18/07	NELL	2/6/08	RFEP
																							N	8/23/05	NELL	2/6/08	RFEP
																							N	8/30/05	NELL	2/6/08	RFEP
																							N	9/25/06	NELL	2/6/08	RFEP
																							N	1/25/05	NELL	2/7/08	RFEP
																							N	9/20/04	NELL	2/7/08	RFEP
																							N	8/22/05	NELL	2/12/08	RFEP
																							N	9/6/05	NELL	2/14/08	RFEP
																							N	9/25/02	NELL	2/14/08	RFEP
																							N	8/27/01	NELL	2/19/08	RFEP
																							N	8/17/05	NELL	2/19/08	RFEP
																							N			2/22/08	RFEP
																							N	4/16/07	TCEL	2/22/08	RFEP
																							N	8/29/03	NELL	2/22/08	RFEP
																							N	8/19/05	NELL	2/26/08	RFEP
																							N	9/16/03	NELL	2/26/08	RFEP
																							N	11/10/03	NELL	2/26/08	RFEP
																							N	9/12/03	NELL	2/26/08	RFEP
																							N	9/15/03	NELL	2/26/08	RFEP
																							N	9/17/03	NELL	3/6/08	RFEP
																							N	9/25/03	NELL	3/6/08	RFEP
																							N	2/1/06	NELL	3/6/08	RFEP
																							N	9/15/03	NELL	3/6/08	RFEP
																							N	9/17/03	NELL	3/6/08	RFEP
																							N	8/28/03	NELL	3/6/08	RFEP
																							N	9/14/06	NELL	3/6/08	RFEP
																							N	9/19/02	NELL	3/6/08	RFEP
																							N	2/27/02	NELL	3/6/08	RFEP
																							N	3/28/07	TCEL	3/6/08	RFEP
																							N	9/8/04	NELL	3/13/08	RFEP
																							N	2/8/07	TCEL	3/25/08	RFEP
																							N	9/8/05	NELL	3/26/08	RFEP
																							N	8/16/05	NELL	3/26/08	RFEP
																							N	11/16/06	TCEL	3/26/08	RFEP
																							N	12/4/0

1 Contributor
0 Replies
110 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.