Recognize Text within Excel

S

SLD

How do I recognize text in one cell and use that to drive
whether or not and entry is made in the cell next to it?

Example: If cell A1=any text, then A2=yes
 
R

RagDyer

In A2 enter:

=IF(ISTEXT(A1),"Yes","No")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I recognize text in one cell and use that to drive
whether or not and entry is made in the cell next to it?

Example: If cell A1=any text, then A2=yes
 
Top