Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
How to enter a two line column heading in excel | New Users to Excel | |||
Alt Enter in a cell | Excel Discussion (Misc queries) | |||
"Enter" in Macros | Excel Discussion (Misc queries) | |||
Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) |