Tech Support Guy banner
Status
Not open for further replies.
1 - 7 of 7 Posts

·
Registered
Joined
·
3 Posts
Discussion Starter · #1 ·
Hi, I´d like to know if it is possible (and if that is the case, how) to use an excel formula that contains if, and, or (all 3 in the same formula).

this is what I had in mind, but I did not get the result I expected.

" =If(Or(And(Psych!R11="+"|Psych!Q8>=4|Or(Psych!O11="-")))|1|"") "

(In this case, eventhough Psych!o11="-" (True), I still get a blank cell as a result instead of a 1.

I do appreciate your help.
JP
 

·
Registered
Joined
·
4,193 Posts
I chuckled after you type solved hehe. I almost spit the burger out that I was eating hehe.

At the very top of your post is an arrow that points down beside some text that says "Thread tools." Please click on that while logged in and select "Mark Solved" from that drop-down list.

Again welcome to the forum and if you have any other questions then feel free to post. ;)
 

·
Retired Moderator
Joined
·
106,726 Posts
I've marked your thread solved for you. If it doesn't appear in the Thread Tools, see if you have JAVA and JAVA Script enabled in your browser.
 
1 - 7 of 7 Posts
Status
Not open for further replies.
Top