I tried, but...
 

Hello.

I have a seemingly simple (but I can't figure it out...) question:

I'm trying to use And/Or functions to pull data form an Excel worksheet.

Column B has form types (i.e. I140), while column M has Preference Codes
(i.e. A, b, c, ext). Now what I am tryig to do is say
=if(B26="I140",AND(OR(J26="A",J26="B",J26="C"),"Fi rst Preference", "Second
Preference")). Isn't working. What I want is if form = I140, and the code
is either A or B or C, then shopw me "First Preference", else show Second
Preference. I also wish to sting out to do a few more test (not to exceed
the excel limit of 7), but I have to get the first one working.

Any suggestions?

Thqnk you.

Mark

I tried, but...
 

then..

=IF(AND(B26="I140",OR(J26="A",J26="B",J26="C")),"" First Preference","Second
Preference")

Although, slightly disconcerting if you're going to add a signifcant number
of variables to a single formula...

"NWO" wrote:

Hello.

I have a seemingly simple (but I can't figure it out...) question:

I'm trying to use And/Or functions to pull data form an Excel worksheet.

Column B has form types (i.e. I140), while column M has Preference Codes
(i.e. A, b, c, ext). Now what I am tryig to do is say
=if(B26="I140",AND(OR(J26="A",J26="B",J26="C"),"Fi rst Preference", "Second
Preference")). Isn't working. What I want is if form = I140, and the code
is either A or B or C, then shopw me "First Preference", else show Second
Preference. I also wish to sting out to do a few more test (not to exceed
the excel limit of 7), but I have to get the first one working.

Any suggestions?

Thqnk you.

Mark

I tried, but...
 

Try this


=IF(AND(B26="I140",OR(J26="A",J26="B",J26="C")),"F irst Preference","Second
Preference")

--


Regards,


Peo Sjoblom


"NWO" wrote in message
...
Hello.

I have a seemingly simple (but I can't figure it out...) question:

I'm trying to use And/Or functions to pull data form an Excel worksheet.

Column B has form types (i.e. I140), while column M has Preference Codes
(i.e. A, b, c, ext). Now what I am tryig to do is say
=if(B26="I140",AND(OR(J26="A",J26="B",J26="C"),"Fi rst Preference", "Second
Preference")). Isn't working. What I want is if form = I140, and the
code
is either A or B or C, then shopw me "First Preference", else show Second
Preference. I also wish to sting out to do a few more test (not to exceed
the excel limit of 7), but I have to get the first one working.

Any suggestions?

Thqnk you.

Mark

I tried, but...
 

Ok, that part works. Now how do I extend the formulas to check for, say, 3
more conditions (i.e. Form = I140, code = D or I, "2nd Pref"; Form =I140,
code = E or G, "3rd Pref", Form =I130, code = A, B, or E, "Pref", Form =
I130, Not A, B, or E, "No Pref").

Thank you.


"Sean Timmons" wrote:

then..

=IF(AND(B26="I140",OR(J26="A",J26="B",J26="C")),"" First Preference","Second
Preference")

Although, slightly disconcerting if you're going to add a signifcant number
of variables to a single formula...

"NWO" wrote:

Hello.

I have a seemingly simple (but I can't figure it out...) question:

I'm trying to use And/Or functions to pull data form an Excel worksheet.

Column B has form types (i.e. I140), while column M has Preference Codes
(i.e. A, b, c, ext). Now what I am tryig to do is say
=if(B26="I140",AND(OR(J26="A",J26="B",J26="C"),"Fi rst Preference", "Second
Preference")). Isn't working. What I want is if form = I140, and the code
is either A or B or C, then shopw me "First Preference", else show Second
Preference. I also wish to sting out to do a few more test (not to exceed
the excel limit of 7), but I have to get the first one working.

Any suggestions?

Thqnk you.

Mark

I tried, but...
 

Try

=IF(AND(B26="I140",OR(J26="A",J26="B",J26="C")),"1 st
Pref",IF(AND(B26="I140",OR(J26="D",J26="I")),"2nd
Pref",IF(AND(B26="I140",OR(J26="E",J26="E")),"3rd
Pref",IF(AND(B26="I130",OR(J26="A",J26="B",J26="E" )),"Pref",IF(B26="I130","No
Pref","???")))))

Hope this helps,

Hutch

"NWO" wrote:

Ok, that part works. Now how do I extend the formulas to check for, say, 3
more conditions (i.e. Form = I140, code = D or I, "2nd Pref"; Form =I140,
code = E or G, "3rd Pref", Form =I130, code = A, B, or E, "Pref", Form =
I130, Not A, B, or E, "No Pref").

Thank you.


"Sean Timmons" wrote:

then..

=IF(AND(B26="I140",OR(J26="A",J26="B",J26="C")),"" First Preference","Second
Preference")

Although, slightly disconcerting if you're going to add a signifcant number
of variables to a single formula...

"NWO" wrote:

Hello.

I have a seemingly simple (but I can't figure it out...) question:

I'm trying to use And/Or functions to pull data form an Excel worksheet.

Column B has form types (i.e. I140), while column M has Preference Codes
(i.e. A, b, c, ext). Now what I am tryig to do is say
=if(B26="I140",AND(OR(J26="A",J26="B",J26="C"),"Fi rst Preference", "Second
Preference")). Isn't working. What I want is if form = I140, and the code
is either A or B or C, then shopw me "First Preference", else show Second
Preference. I also wish to sting out to do a few more test (not to exceed
the excel limit of 7), but I have to get the first one working.

Any suggestions?

Thqnk you.

Mark