Comparing Cells

[gdeleos]

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!

[Daniel CHEN]

Try to use the following formula:

=If(and(B1="",C1="Y"),A1,"")

(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
=================================

"gdeleos" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=32540
> View this thread: http://www.excelforum.com/showthread...hreadid=523249
>

[Domenic]

Try...

=IF(B1="",IF(C1="Y",A1,""),"")

Hope this helps!

In article <[email protected]>,
gdeleos <[email protected]> wrote:

> 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!