Checking if 2 of 3 conditions are met...

Giganews Newsgroups
Subject: Checking if 2 of 3 conditions are met...
Posted by:  guilbj2 (guilbj2.2a64go_1151592038.8097@excelforum-nospam.com)
Date: Thu, 29 Jun 2006

I'm trying to figure out an =IF to check if 2 of 3 conditions are met.
The conditions are as follows

E="Y"
H3>=10
I3="Win"

What I'm trying to do is set the value in a cell to "Pass" if ANY 2 (or
all 3) of the conditions are met.  Any ideas?

--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=6043
View this thread:http://www.excelforum.com/showthread.php?threadid=556935

Replies