Is there a (non-binary) "if x then enter y" forumula?

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." <[email protected]> wrote in message
news:[email protected]...
>
> "Anne Troy" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

I agree, but it works <vbg>

Bob


"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Bob, that formula is absolutely gross. ROFL!!
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >
>
=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." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> > >
> > >
> >
> >
>
>

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 <[email protected]>, [email protected]
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!
>
>
>

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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.

Bob, that formula is absolutely gross. ROFL!!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
=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." <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> >
> >
>
>

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =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.

=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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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)

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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

Bob, that formula is absolutely gross. ROFL!!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
=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." <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> >
> >
>
>

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." <[email protected]> wrote in message
news:[email protected]...
>
> "Anne Troy" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

I agree, but it works <vbg>

Bob


"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Bob, that formula is absolutely gross. ROFL!!
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >
>
=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." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> > >
> > >
> >
> >
>
>

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =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.

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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.

=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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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)

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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

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 <[email protected]>, [email protected]
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!
>
>
>

I agree, but it works <vbg>

Bob


"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Bob, that formula is absolutely gross. ROFL!!
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> >
>
=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." <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> > >
> > >
> >
> >
>
>

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 <[email protected]>, [email protected]
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!
>
>
>

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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.

Bob, that formula is absolutely gross. ROFL!!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
=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." <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> >
> >
>
>

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." <[email protected]> wrote in message
news:[email protected]...
>
> "Anne Troy" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =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.

=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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> 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)

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." <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>

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!