If(not(A2="FL","AL".... ),"other",A2) IF(not help
 

Column A is a list of states. If column A is not 7 specific states, then i
want "other" if it is one of these states, then i want the state (ie A2 etc).
I'm trying to use If(not(.... but there are too many arguements. Any
suggestions would be greatly appreciated!!!

attempt:

If(not(A2="FL","AL".... ),"other",A2)

Then I am then using an Index Match function to find the pay rate for the
"new state" (column B) along with another cell reference to the job
description.

If(not(A2="FL","AL".... ),"other",A2) IF(not help
 

How about

=if(SUMPRODUCT((I5={"a","b","d"})*1)<1,"other",i5)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jchick0909" wrote in message
...

Column A is a list of states. If column A is not 7 specific states, then
i
want "other" if it is one of these states, then i want the state (ie A2
etc).
I'm trying to use If(not(.... but there are too many arguements. Any
suggestions would be greatly appreciated!!!

attempt:

If(not(A2="FL","AL".... ),"other",A2)

Then I am then using an Index Match function to find the pay rate for the
"new state" (column B) along with another cell reference to the job
description.

If(not(A2="FL","AL".... ),"other",A2) IF(not help
 

One way:

=IF(OR(A1={"al","wi","in","il"}),A1,"other")



jchick0909 wrote:

Column A is a list of states. If column A is not 7 specific states, then i
want "other" if it is one of these states, then i want the state (ie A2 etc).
I'm trying to use If(not(.... but there are too many arguements. Any
suggestions would be greatly appreciated!!!

attempt:

If(not(A2="FL","AL".... ),"other",A2)

Then I am then using an Index Match function to find the pay rate for the
"new state" (column B) along with another cell reference to the job
description.

--

Dave Peterson

If(not(A2="FL","AL".... ),"other",A2) IF(not help
 

Hi,

In cell B2, enter the following array formula (Ctrl+Shift+Enter)

=IF(NOT(OR(A2=$D$5:$D$11)),"Other",A2). D5:D11 contains the 7 entries.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jchick0909" wrote in message
...

Column A is a list of states. If column A is not 7 specific states, then
i
want "other" if it is one of these states, then i want the state (ie A2
etc).
I'm trying to use If(not(.... but there are too many arguements. Any
suggestions would be greatly appreciated!!!

attempt:

If(not(A2="FL","AL".... ),"other",A2)

Then I am then using an Index Match function to find the pay rate for the
"new state" (column B) along with another cell reference to the job
description.