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

  • Thread starter Thread starter jchick0909
  • Start date Start date
J

jchick0909

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.
 
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
 
Back
Top