How do you make cell 2 return data if cell 1 contains text?
 

If cell A1 contains a contact's name I want cell A2 to automatically
return a response of "Lead" and if cell A1 is blank I want cell A2 to
remain blank

I assume I need a formula in A2 to this effect but am not sure how to
make it recoginze it correctly.

=IF(A1=???,"Lead")

The question marks in red is what i don't know what to say.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498498

How do you make cell 2 return data if cell 1 contains text?
 

Any of these help:

=IF(A1<"","LEAD","")

=IF(A10,"LEAD","")

=IF(ISTEXT(A1),"LEAD","")
?
--
HTH,

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


"jermsalerms"
wrote in message
...

If cell A1 contains a contact's name I want cell A2 to automatically
return a response of "Lead" and if cell A1 is blank I want cell A2 to
remain blank

I assume I need a formula in A2 to this effect but am not sure how to
make it recoginze it correctly.

=IF(A1=???,"Lead")

The question marks in red is what i don't know what to say.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498498

How do you make cell 2 return data if cell 1 contains text?
 

Worked like a charm:)


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498498

How do you make cell 2 return data if cell 1 contains text?
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jermsalerms"
wrote in message
...

Worked like a charm:)


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498498