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