Conditional cell
 

I have a dropdown menu in cell A1 that is either Yes or No.
I want cell C1 to display "Data Required" if A1 = Yes and is left blank
if A1 = No.
How do I program cell C1??


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=538860

Conditional cell
 

=if(a1="yes","data required","")
or
=if(a1="yes","data required",if(a1="no","","Not Yes and Not No"))





grahammal wrote:

I have a dropdown menu in cell A1 that is either Yes or No.
I want cell C1 to display "Data Required" if A1 = Yes and is left blank
if A1 = No.
How do I program cell C1??

--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=538860

--

Dave Peterson

Conditional cell
 

=IF(A1="Yes","Data Required","")

This assumes that A1 will always be "Yes" , "No" or blank.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=538860

Conditional cell
 

Ignore my previous comment, what I meant to say was it assumes that you
want to return blank if any value other than "Yes" is in A1.

Regards,
Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=538860

Conditional cell
 

Thanx for your help, now works perfectly.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=538860

Conditional cell
 

IN cell C1 put this formula............

=IF(A1="yes","Date required","")

Vaya con Dios,
Chuck, CABGx3



"SteveG" wrote:


=IF(A1="Yes","Data Required","")

This assumes that A1 will always be "Yes" , "No" or blank.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=538860