Bob, that formula is absolutely gross. ROFL!!
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Bob Phillips" wrote in message
...
=VLOOKUP(A1,{"Clinton",0.25;"Bush",0.25;"Carter",0 .25;"Taylor",0.37;"Washing
ton",0.37;"Adams",0.37;"Roosevelt",0.45;"Nixon",0. 54;"Pierce",0.99},2,FALSE)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Julie P." wrote in message
...
Hi, I am looking for a formula that does the following:
if "Clinton", "Bush", or "Carter", then enter "$0.25"
if "Taylor", "Washington", or "Adams", then enter "$0.37"
if "Roosevelt", then enter "$0.45"
if "Nixon", then enter "$0.54"
if "Pierce", then enter "$0.99"
Is there such a formula. More importantly, is there such a formula that
is
not binary, since I would prefer not to have to use nesting.
Thanks!