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" wrote in
message ...
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