Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters) and
if they equal "A123" or "A234" - a result will display in another cell.

I was trying this
=IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive"))

Any ideas?

Thanks in advance

=IF(OR(LEFT(D2,4)="A123",LEFT(D2,4)="A234"),"Activ e","Inactive")


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"EJB" wrote in message
...
Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters)
and
if they equal "A123" or "A234" - a result will display in another cell.

I was trying this
=IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive"))

Any ideas?

Thanks in advance

You just have a couple of brackets wrong.

Try this:

=IF(OR(LEFT(D2,4)="A123",LEFT(D2,4)="A234"),"Activ e","Inactive")

Judith
--
Hope this helps


"EJB" wrote:

Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters) and
if they equal "A123" or "A234" - a result will display in another cell.

I was trying this
=IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive"))

Any ideas?

Thanks in advance

Thanks Bob and Judith, so close but so far :)
It works perfectly now!
Much appreciated

"JudithJubilee" wrote:

You just have a couple of brackets wrong.

Try this:

=IF(OR(LEFT(D2,4)="A123",LEFT(D2,4)="A234"),"Activ e","Inactive")

Judith
--
Hope this helps


"EJB" wrote:

Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters) and
if they equal "A123" or "A234" - a result will display in another cell.

I was trying this
=IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive"))

Any ideas?

Thanks in advance

Try this:

=IF(OR(LEFT(D2,4)={"A123","A234"}),"Active","Inact ive")


"EJB" wrote:

Hi, I am trying to write a "combination" IF formula that will look at the
first 4 characters in a cell (in total in a cell there are 8 characters) and
if they equal "A123" or "A234" - a result will display in another cell.

I was trying this
=IF(Or(LEFT(D2,4)="A123",(LEFT(D2,4)="A234"),"Acti ve","Inactive"))

Any ideas?

Thanks in advance