=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!