Thanks Bob. That did it.


"Bob Phillips" wrote:

=IF(LEFT(L1,1)="C","110",IF(LEFT(L1,1)="A","250",I F(LEFT(L1,1)="E","350","")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Monte" wrote in message
...

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,
anysuggestions?

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