Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 20th 05, 11:42 PM
Julie P.
 
Posts: n/a
Default Is there a (non-binary) "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   Report Post  
Old June 20th 05, 11:45 PM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old June 20th 05, 11:52 PM
Julie P.
 
Posts: n/a
Default


"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   Report Post  
Old June 21st 05, 12:31 AM
Bob Phillips
 
Posts: n/a
Default

=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   Report Post  
Old June 21st 05, 12:42 AM
Julie P.
 
Posts: n/a
Default


"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   Report Post  
Old June 21st 05, 12:57 AM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old June 21st 05, 12:57 AM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old June 21st 05, 02:52 AM
Julie P.
 
Posts: n/a
Default


"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   Report Post  
Old June 21st 05, 02:34 PM
Tushar Mehta
 
Posts: n/a
Default

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.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, 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   Report Post  
Old June 21st 05, 08:49 PM
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
How to enter a two line column heading in excel Sharon New Users to Excel 9 April 6th 05 06:49 PM
Alt Enter in a cell JJ Excel Discussion (Misc queries) 2 March 25th 05 11:44 PM
"Enter" in Macros Desperate Excel Discussion (Misc queries) 4 February 26th 05 03:43 AM
Enter last name, auto fill full name & address--HOW? ana maria Excel Discussion (Misc queries) 3 February 25th 05 08:28 PM


All times are GMT +1. The time now is 07:51 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017