• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • Last Modified:

Excel Formula



   a          b             c         d
Yes      Open   YES         0

then the answer in e should be Y

a         b             c         d
Yes      Open   YES         7

Then the answer should be N

But they both return Y for me.

Your assistance is greatly appreciated.
  • 2
  • 2
1 Solution
Saqib Husain, SyedEngineerCommented:
Can you explain in english what you want to achieve.

Till then try

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Two things.

1. It's because you are using:
=IF(OR - in order words, only one of the conditions needs to be true.

Secondly, I would suggest reducing the number of IFs:

JagwarmanAuthor Commented:

I think there is a piece missing from your solutions, either that or I am going completely mad

the query is:

If A2 =Yes and B2 = Open or Book and C2 = Yes and D2 =0 or 1 then the answer is Yes otherwise No

Thanks for your help with this
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
JagwarmanAuthor Commented:
How do you do that so quick Phillip. Brilliant thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now