Juls, it sounds like VLOOKUP would do better for you. You can create a table
for each of the presidents in column A, then put the values in column B.
These can even be on a hidden worksheet. Here's how:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"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!