Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can wildcards be used in the Logic Test of an Excel "IF" function?
Currently, I'm using seven nested "IF" functions to return one of three
account numbers. Is it possible to use a wildcard in the Logic Test to decrease the formula to three nested "IF" functions? If so, how? If not, any suggestions? current formula: =if (cell contents = "CIR CC", return "110",if (cell contents = "CIR PC", return "110",if (cell contents = "ADV CC", return "250",if (cell contents = "ADV PC", return "250",if (cell contents = "ED CC", return "350",if (cell contents = "ED PC", return "350","")))))) desired formula: =if (cell contents begins with "C", return "110",if(cell contents begins with "A", return "250",if(cell contents begins with "E", return "350", otherwise ""))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
logic stmt. use in a new workbook w/o refering back to original | Excel Worksheet Functions | |||
Wildcards in Functions | Excel Worksheet Functions | |||
vlookup & wildcards | Excel Worksheet Functions | |||
Statistic: Problem with two one sided t-test | Excel Discussion (Misc queries) | |||
Excel competency test | Excel Discussion (Misc queries) |