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

J

jermsalerms

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

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

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

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

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]...
 
Top