Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|