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