Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |