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

[jermsalerms]

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.

[RagDyer]

Any of these help:

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

=IF(A1>0,"LEAD","")

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

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


"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[jermsalerms]

Worked like a charm

[RagDyer]

Appreciate the feed-back.
--
Regards,

RD

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

"jermsalerms" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>