Multiple if condition

[RAJESH1960]

Hello
I am trying to work out a formula to match the date and amount. If e2=e3 and if f2=f3 then display true, else false.

query match date and amount.xlsx
	D	E	F
1		Date	Amount
2	FALSE	01-05-2020	10800.00
3	FALSE	01-05-2020	67517.00
4	TRUE	29-09-2020	87091.00
5	TRUE	29-09-2020	87091.00
6	FALSE	24-07-2020	6272.00
7	TRUE	31-10-2020	428.81
8	TRUE	31-05-2020	428.81
9	FALSE	31-01-2021	857.62
10	FALSE	30-09-2020	1286.43
11	TRUE	29-06-2020	114534.00
12	TRUE	29-06-2020	114534.00
13	TRUE	27-07-2020	275940.00
14	TRUE	27-07-2020	275940.00
15	TRUE	12-12-2020	13650.00
16	TRUE	12-12-2020	13650.00
17	FALSE	05-01-2021	32193.00
18	FALSE	04-07-2020	32340.00
19	FALSE	05-07-2020	32340.00
20	FALSE	18-08-2020	2604.00
21	FALSE	13-03-2020	2633.00
Reconcile

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E27:F1048576,E1:F19	Expression	=COUNTIFS($B$1:$B$1428,$B1,$F$1:$F$1428,"<"&$F1+0.5,$F$1:$F$1428,">"&$F1-0.5)=1	text	NO

 

[Joe4]

Place this in cell E2 and copy down for all rows:

=OR(AND(E2=E3,F2=F3),AND(E2=E1,F2=F1))

 

[RAJESH1960]

Place this in cell E2 and copy down for all rows:

=OR(AND(E2=E3,F2=F3),AND(E2=E1,F2=F1))

Thanks Joe. You just saved a lot of my time.

 

[Joe4]

You are welcome.

They key is that you need to check not only the row below the current row, but also the row above the current row for each entry.
Since OR and AND are boolean functions, you do not need an IF, since boolean functions return TRUE/FALSE, by definition.

 

[RAJESH1960]

You are welcome.

They key is that you need to check not only the row below the current row, but also the row above the current row for each entry.
Since OR and AND are boolean functions, you do not need an IF, since boolean functions return TRUE/FALSE, by definition.

Thanks. Noted.