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
|