Nested IF/AND/STATEMENT

[Pika735]

Date of review	Checks on	ACTION
01/25/22	1/22/22	N/A
1/22/22	1/25/22	TRUE
1/23/22	1/26/22	FALSE

IF Date of review is before Checks on and action is true = Pass
IF Date of review is after checks on and action is N/A = Pass
IF Date of review is before Checks in on and action is false = Fail

I am having issues with the nested if statement

 

[jtakw]

Hi,

See if this works for you:

Book3.xlsx
	A	B	C	D
1	Date of review	Checks on	ACTION
2	1/25/2022	1/22/2022	N/A	Pass
3	1/22/2022	1/25/2022	TRUE	Pass
4	1/23/2022	1/26/2022	FALSE	Fail
Sheet1008

Cell Formulas
Range	Formula
D2:D4	D2	=IF(A2<B2,IF(C2,"Pass","Fail"),"Pass")