Using Microsoft Excel 2003...

I am working on creating an "IF" Function and here is what I would like for
it to do.
I have Column A filled in with all these ID's that start with either TRE or
CL.
In Column B I would like an if function that will T if the info in Column A
begins with TRE and C if it begins with CL.

Thanks

=LEFT(A1,1)

no IFs are needed
--
Gary''s Student - gsnu200834


"Dave" wrote:

Using Microsoft Excel 2003...

I am working on creating an "IF" Function and here is what I would like for
it to do.
I have Column A filled in with all these ID's that start with either TRE or
CL.
In Column B I would like an if function that will T if the info in Column A
begins with TRE and C if it begins with CL.

Thanks

On Feb 18, 9:35 am, Dave wrote:
In Column B I would like an if function that will T
if the info in Column A begins with TRE and C if it
begins with CL.

The simplest formula might be:

=left(A1,1)

But that assumes that A1 contains only "TRE..." or "CL...", or you
don't really care.

A more careful formula might be:

=if(left(A1,2)="CL","C",if(left(A1,3)="TRE","T","" ))


----- original posting -----

On Feb 18, 9:35*am, Dave wrote:
Using Microsoft Excel 2003...

I am working on creating an "IF" Function and here is what I would like for
it to do. *
I have Column A filled in with all these ID's that start with either TRE or
CL.
In Column B I would like an if function that will T if the info in Column A
begins with TRE and C if it begins with CL.

Thanks

If those are the only 2 options, =LEFT(A2) and copy down (unless you
*really* insist on using IF).
--
David Biddulph

"Dave" wrote in message
...
Using Microsoft Excel 2003...

I am working on creating an "IF" Function and here is what I would like
for
it to do.
I have Column A filled in with all these ID's that start with either TRE
or
CL.
In Column B I would like an if function that will T if the info in Column
A
begins with TRE and C if it begins with CL.

Thanks