software

BHi All,
I am new to excel, so any help would be great
I want to automatically insert a set text string for instance, ABC into A1
only if there is a number inserted into cell B1 for instance 12345.
So if I insert 12345 into cell B1, A1 would then show ABC, if I insert 6789
into B2, A2 would then again return ABC.
However if there is no value in B1 or B2 then I need A1 and A2 to be blank
and not return N/A# etc

=IF(B1=12345,quot;ABCquot;,quot;quot;)

put that formula in A1 and copy to A2

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Racingzeusquot; gt; wrote in message
...
gt; BHi All,
gt; I am new to excel, so any help would be great
gt; I want to automatically insert a set text string for instance, ABC into
A1
gt; only if there is a number inserted into cell B1 for instance 12345.
gt; So if I insert 12345 into cell B1, A1 would then show ABC, if I insert
6789
gt; into B2, A2 would then again return ABC.
gt; However if there is no value in B1 or B2 then I need A1 and A2 to be blank
gt; and not return N/A# etc
if you have more than one set of matchings text/number sets may help
lt;A
HREF=quot;www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.miscamp;lang=e namp;cr=USquot;gt;this threadlt;/Agt; may help

www.microsoft.com/office/comm...ang=e namp;cr=US
--
paul
remove nospam for email addy!
quot;Racingzeusquot; wrote:

gt; BHi All,
gt; I am new to excel, so any help would be great
gt; I want to automatically insert a set text string for instance, ABC into A1
gt; only if there is a number inserted into cell B1 for instance 12345.
gt; So if I insert 12345 into cell B1, A1 would then show ABC, if I insert 6789
gt; into B2, A2 would then again return ABC.
gt; However if there is no value in B1 or B2 then I need A1 and A2 to be blank
gt; and not return N/A# etc

href=www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.miscamp;mid=05 5d688b-4330-4e02-8385-da7e540725ee
--
paul
remove nospam for email addy!
quot;paulquot; wrote:

gt; if you have more than one set of matchings text/number sets may help
gt; lt;A
gt; HREF=quot;www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.miscamp;lang=e namp;cr=USquot;gt;this threadlt;/Agt; may help
gt;
gt; www.microsoft.com/office/comm...ang=e namp;cr=US
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Racingzeusquot; wrote:
gt;
gt; gt; BHi All,
gt; gt; I am new to excel, so any help would be great
gt; gt; I want to automatically insert a set text string for instance, ABC into A1
gt; gt; only if there is a number inserted into cell B1 for instance 12345.
gt; gt; So if I insert 12345 into cell B1, A1 would then show ABC, if I insert 6789
gt; gt; into B2, A2 would then again return ABC.
gt; gt; However if there is no value in B1 or B2 then I need A1 and A2 to be blank
gt; gt; and not return N/A# etc

Hi Bob,
I have tried the formula and it only works if the number I input into B1 is
=12345 so I have modified it to =IF(B1gt;=0,quot;ABCquot;,quot;quot;) so that any number I
enterin B1 will return ABC in cell A1.
This formula works just as I want it except that when I copy this formula
into cells A2 through to A20 then these cells reveal ABC even though I have
not input any number in the cells B2 through B20. I need cells A2 through A20
to remain blank unless there is a number in the corresponding B cells.

Cheers for all your help
Dave
quot;Bob Phillipsquot; wrote:

gt; =IF(B1=12345,quot;ABCquot;,quot;quot;)
gt;
gt; put that formula in A1 and copy to A2
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Racingzeusquot; gt; wrote in message
gt; ...
gt; gt; BHi All,
gt; gt; I am new to excel, so any help would be great
gt; gt; I want to automatically insert a set text string for instance, ABC into
gt; A1
gt; gt; only if there is a number inserted into cell B1 for instance 12345.
gt; gt; So if I insert 12345 into cell B1, A1 would then show ABC, if I insert
gt; 6789
gt; gt; into B2, A2 would then again return ABC.
gt; gt; However if there is no value in B1 or B2 then I need A1 and A2 to be blank
gt; gt; and not return N/A# etc
gt;
gt;
gt;


Try

=IF(ISNUMBER(B1),quot;abcquot;,quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=516536