Help with formulae

[Racingzeus]

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

[Bob Phillips]

=IF(B1=12345,"ABC","")

put that formula in A1 and copy to A2

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

[paul]

if you have more than one set of matchings text/number sets may help
<A
HREF="http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=en&cr=US">this thread</A> may help

http://www.microsoft.com/office/comm...&lang=en&cr=US
--
paul
remove nospam for email addy!



"Racingzeus" wrote:

> 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

[paul]

href=http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&mid=055d688b-4330-4e02-8385-da7e540725ee
--
paul
remove nospam for email addy!



"paul" wrote:

> if you have more than one set of matchings text/number sets may help
> <A
> HREF="http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&lang=en&cr=US">this thread</A> may help
>
> http://www.microsoft.com/office/comm...&lang=en&cr=US
> --
> paul
> remove nospam for email addy!
>
>
>
> "Racingzeus" wrote:
>
> > 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

[Racingzeus]

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(B1>=0,"ABC","") 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
"Bob Phillips" wrote:

> =IF(B1=12345,"ABC","")
>
> put that formula in A1 and copy to A2
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Racingzeus" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>

[daddylonglegs]

Try

=IF(ISNUMBER(B1),"abc","")