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 "")))