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

aljrab · 10-21-2007, 11:20 PM

A B
SO number SO item
1: 12217379 1100
2: 12217379 1100
3: 12837633 200
4: 12837633 300
5: 12894024 100

Hi i am trying to have a formula that lets me test IF A3=A4 and IF B3= B4 OR IF A3=A2 and B3=B2 then return double if both conditions are false then return OK

At the moment I am only able to test one of my conditions IF((AND(A3=A4,B3=B4)),"Double", "OK")

but I am not knowing how to integrate the OR function in to the formula\

Any help would be much appreciated

Thanks

10-21-2007, 11:20 PM	#1 (permalink)
aljrab Registered User Join Date: Jun 2007 Posts: 2 OS: winXP	Excel IF Function containing the AND and OR FUnction A B SO number SO item 1: 12217379 1100 2: 12217379 1100 3: 12837633 200 4: 12837633 300 5: 12894024 100 Hi i am trying to have a formula that lets me test IF A3=A4 and IF B3= B4 OR IF A3=A2 and B3=B2 then return double if both conditions are false then return OK At the moment I am only able to test one of my conditions IF((AND(A3=A4,B3=B4)),"Double", "OK") but I am not knowing how to integrate the OR function in to the formula\ Any help would be much appreciated Thanks