Home 
Search 
Today's Posts 
#1




Is there a (nonbinary) "if x then enter y" forumula?
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! 
#2




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! 
#3




"Anne Troy" wrote in message news:[email protected] s.com... 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 Thanks again Anne! I looked at that site, and will have to study it. It seems really complex, but maybe I will be able to work it out. Otherwise, I will do nested formulae. But I do not know the syntax. I think it is this: =if(argument 1, output if true, output if false) 
#4




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




"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) Wow! Thanks so much Bob. It worked! This is so much easier than doing a binary and nested if formula. 
#6




Yes. I also explain IF statements in another article there. But if you dont'
know VLOOKUP yet, you really should learn it. It's invaluable. Also, try this sample workbook I created: http://www.myexpertsonline.com/freedls/pricelist.xls Maybe it'll help you "get it". ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Julie P." wrote in message ... "Anne Troy" wrote in message news:[email protected] s.com... 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 Thanks again Anne! I looked at that site, and will have to study it. It seems really complex, but maybe I will be able to work it out. Otherwise, I will do nested formulae. But I do not know the syntax. I think it is this: =if(argument 1, output if true, output if false) 
#7




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! 
#8




"Anne Troy" wrote in message news:[email protected] com... Yes. I also explain IF statements in another article there. But if you dont' know VLOOKUP yet, you really should learn it. It's invaluable. Also, try this sample workbook I created: http://www.myexpertsonline.com/freedls/pricelist.xls Maybe it'll help you "get it". ******************* Anne, thanks so much for your time and effort, and also for creating those pages! I will see what I can learn. 
#9




Here's a much cleaner way of implementing a VLOOKUP  without creating
a nightmare in trying to understand or maintain your worksheet. Put the various entries in a table. I selected A3:B11 Clinton 0.25 Bush 0.25 Carter 0.25 Roosevelt 0.45 Nixon 0.54 Pierce 0.99 Taylor 0.37 Washington 0.37 Adams 0.37 Now, suppose the entity you are searching for is in C3. Then, the formula =VLOOKUP(C3,A3:B11,2,FALSE) will give you what you want. And, the overall result is so much easier to understand and maintain!  Regards, Tushar Mehta www.tusharmehta.com Excel, PowerPoint, and VBA addins, tutorials Custom MS Office productivity solutions In article , says... 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! 
#10




I agree, but it works <vbg
Bob "Anne Troy" wrote in message news:[email protected] com... 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! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
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 & addressHOW?  Excel Discussion (Misc queries) 