If Or Or Or Statement Then

[elsaidmi]

Good afternoon,

I need to write a formula that does the following:

If cell is (#### or #### or any letter combination) then put "MA"
if cell is (#### or ####) then put "SC"

#### stand for a combination of a few numbers.

Haven't been able to figure it out. Thank you!

 

[gaz_chops]

Is #### letters or numbers?
You say "(#### or #### or any letter combination)" then "#### stand for a combination of a few numbers"

 

[Special-K99]

Base something on this

=IF(OR(A1="abc",A1="def",A1="ghi"),"MA",IF(OR(A1="jkl",A1="mno"),"SC","Neither"))

Change the values as necessary.

You'll need to be specific on what "a combinationo of a few numbers" is.

 

[elsaidmi]

Base something on this

=IF(OR(A1="abc",A1="def",A1="ghi"),"MA",IF(OR(A1="jkl",A1="mno"),"SC","Neither"))

Change the values as necessary.

You'll need to be specific on what "a combinationo of a few numbers" is.

Thank you - #### stands for a combination of numbers

 

[gaz_chops]

So as Special-K99 says,
=if(or(A1=1234,A1=2345),"MA",if(or(A1=4567,A1=5678),"SC","")

 

[Mackers]

Bear in mind that if you are checking for numbers, you don't need the inverted commas.

Using Special-K99's formula layout, say if you want everything that has 1111, 2222 or any letter combination to be MA, and 3333 or 4444 to be SC:

=IF(OR(A1=1111, A1=2222, ISTEXT(A1)), "MA", IF(OR(A1=3333, A1=4444), "SC", "Neither"))

 

[elsaidmi]

Bear in mind that if you are checking for numbers, you don't need the inverted commas.

Using Special-K99's formula layout, say if you want everything that has 1111, 2222 or any letter combination to be MA, and 3333 or 4444 to be SC:

=IF(OR(A1=1111, A1=2222, ISTEXT(A1)), "MA", IF(OR(A1=3333, A1=4444), "SC", "Neither"))

Perfect!! Do you know another way I can do this data? Here are more details...

I have a list of numbers = MA , a list of numbers = SC, but I also have a list of letter combinations that can change that would also equal MA.


instead of listing the choices 1111,2222,3333,4444, is it possible to have it search through a compiled list for each one? And then also keep the test for istext instead of listing out the letter combinations because those change often...

Thank you very much for your help!

 

[Mackers]

If you have a list on a separate sheet, the usual way I would check is something like:

=IF(OR(NOT(ISERROR(MATCH(A1, yourlist, 0))), ISTEXT(A1)), "MA", ... )

Where yourlist is a range of numbers against which you wish to check.

 

[elsaidmi]

If you have a list on a separate sheet, the usual way I would check is something like:

=IF(OR(NOT(ISERROR(MATCH(A1, yourlist, 0))), ISTEXT(A1)), "MA", ... )

Where yourlist is a range of numbers against which you wish to check.

It isn't finding the correct values, here is the first part...
It isn't differentiating between the two, it is finding only "OTHERS" althrough there should be some "M"s

=IF(OR(NOT(ISERROR(MATCH(D19,'OC Helper'!$H$3:$I$20,0)))),"M","OTHER")

 

[elsaidmi]

If you have a list on a separate sheet, the usual way I would check is something like:

=IF(OR(NOT(ISERROR(MATCH(A1, yourlist, 0))), ISTEXT(A1)), "MA", ... )

Where yourlist is a range of numbers against which you wish to check.

never mind - data consistency error!! figured it out! thanks for the help!