software

If cell A1 contains a contact's name I want cell A2 to automatically
return a response of quot;Leadquot; 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=???,quot;Leadquot;)

The question marks in red is what i don't know what to say.--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=498498Any of these help:

=IF(A1lt;gt;quot;quot;,quot;LEADquot;,quot;quot;)

=IF(A1gt;0,quot;LEADquot;,quot;quot;)

=IF(ISTEXT(A1),quot;LEADquot;,quot;quot;)
?
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;jermsalermsquot; gt;
wrote in message
...
gt;
gt; If cell A1 contains a contact's name I want cell A2 to automatically
gt; return a response of quot;Leadquot; and if cell A1 is blank I want cell A2 to
gt; remain blank
gt;
gt; I assume I need a formula in A2 to this effect but am not sure how to
gt; make it recoginze it correctly.
gt;
gt; =IF(A1=???,quot;Leadquot;)
gt;
gt; The question marks in red is what i don't know what to say.
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile:
www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread: www.excelforum.com/showthread...hreadid=498498
gt;
Worked like a charm--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=498498Appreciate the feed-back.
--
Regards,

RD

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

quot;jermsalermsquot; gt;
wrote in message
...
gt;
gt; Worked like a charm
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile:
www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread: www.excelforum.com/showthread...hreadid=498498
gt;