software

I have four columns
A1=Name
B1=Y
C1=
D1=Y

(Y mean yes and blank means no in celss B-D)

What i would like to do is for excel to compare cells B, C, and D and
return the name in A1 if B1 is blank and there is a Y in C1.

Please help...Thanks!--
gdeleos
------------------------------------------------------------------------
gdeleos's Profile: www.excelforum.com/member.php...oamp;userid=32540
View this thread: www.excelforum.com/showthread...hreadid=523249Try to use the following formula:

=If(and(B1=quot;quot;,C1=quot;Yquot;),A1,quot;quot;)

(There is no comparison for cell D1 in your question)

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================

quot;gdeleosquot; gt; wrote in
message ...
gt;
gt; I have four columns
gt; A1=Name
gt; B1=Y
gt; C1=
gt; D1=Y
gt;
gt; (Y mean yes and blank means no in celss B-D)
gt;
gt; What i would like to do is for excel to compare cells B, C, and D and
gt; return the name in A1 if B1 is blank and there is a Y in C1.
gt;
gt; Please help...Thanks!
gt;
gt;
gt; --
gt; gdeleos
gt; ------------------------------------------------------------------------
gt; gdeleos's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32540
gt; View this thread: www.excelforum.com/showthread...hreadid=523249
gt;
Try...

=IF(B1=quot;quot;,IF(C1=quot;Yquot;,A1,quot;quot;),quot;quot;)

Hope this helps!

In article gt;,
gdeleos gt; wrote:

gt; I have four columns
gt; A1=Name
gt; B1=Y
gt; C1=
gt; D1=Y
gt;
gt; (Y mean yes and blank means no in celss B-D)
gt;
gt; What i would like to do is for excel to compare cells B, C, and D and
gt; return the name in A1 if B1 is blank and there is a Y in C1.
gt;
gt; Please help...Thanks!