Tech Support Forum - View Single Post - Excel IF Function containing the AND and OR FUnction

Baldspot · 10-25-2007, 07:10 PM

The AND function gives a True result if All arguments are true.

The OR function gives a True result if Any of the arguments are true:

Here is my data:

COLUMNS ..... A..B..C..D.

ROW 1: .........1 . 1 . 3 . 3 ........=IF(OR(A2=B2,C2=D2),"T","F") = "T"

ROW 2: .........1 . 1 . 3 . 4.........=IF(OR(A3=B3,C3=D3),"T","F") = "T"

ROW 3: .........1 . 2 . 3 . 4 ........=IF(OR(A4=B4,C4=D4),"T","F") = "F"

The OR function can test up to 30 conditions.

=IF(OR(A1=B1,C2=D2,A3=B3,C3=D3),"Y","N") = Y

10-25-2007, 07:10 PM	#2 (permalink)
Baldspot Registered User Join Date: Oct 2007 Posts: 13 OS: Windows 2003	Re: Excel IF Function containing the AND and OR FUnction The AND function gives a True result if All arguments are true. The OR function gives a True result if Any of the arguments are true: Here is my data: COLUMNS ..... A..B..C..D. ROW 1: .........1 . 1 . 3 . 3 ........=IF(OR(A2=B2,C2=D2),"T","F") = "T" ROW 2: .........1 . 1 . 3 . 4.........=IF(OR(A3=B3,C3=D3),"T","F") = "T" ROW 3: .........1 . 2 . 3 . 4 ........=IF(OR(A4=B4,C4=D4),"T","F") = "F" The OR function can test up to 30 conditions. =IF(OR(A1=B1,C2=D2,A3=B3,C3=D3),"Y","N") = Y Last edited by Baldspot; 10-25-2007 at 07:12 PM.