IF, AND & OR

[Denny57]

I cannot seem to get the IF, AND & OR syntax correct for what should be a simple check.

IF Cell B3 = A
AND Cell C3 = N
OR Cell D3 = N
Return Value of Cell B4, else leave blank

=IF(AND(B3="A",C3="N",D13="N"),B4,0)

Hopefully someone can provide the correct solution.

 

[cmowla]

Does this work for you?

=IF(OR(AND(B3="A",C3="N"),D3="N"),B4,"")

 

[Denny57]

=IF(OR(AND(B3="A",C3="N"),D3="N"),B4,"")

Thank you works fine

 

[Denny57]

Sorry but I have just realised that this solution checks to see if any one of the statements is met.

I actually need a solution that allows for a variable value in Cell B3 whilst checking if cells C3 or D3 contain value N

If Cell B3 contains value A then if either Cell C3 or D3 has a value of N then return the value in cell B4, else leave blank
If Cell B3 contains value Z then if either Cell C3 or D3 has a value of N then return the value in cell B4, else leave blank

Aplologies for the confusion

 

[cmowla]

No problem. Does this work for you?

=IF(OR(B3="A",B3="Z"),IF(OR(C3="N",D3="N"),B4,""),"")

 

[Fluff]

Another option

=IF(AND(OR(B3={"A","Z"}),OR(C3="N",D3="N")),B4,"")

 

[Denny57]

=IF(OR(B3="A",B3="Z"),IF(OR(C3="N",D3="N"),B4,""),"")

I will try this, however, the records are in different sheets so I am really looking for two separate but similar solutions, one for each value for Cell B3

 

[Fluff]

In that case can you please explain EXACTLY what it is you are trying to do.
Providing an oversimplified example is never a good idea as you will never get something that works.

 

[Denny57]

Perhaps I can better explain

If Cell B3 = A (Logical Test 1 is True),then IF Cell C3 = N OR Cell D3 = N (Logical test 2 is True) then value = Cell B4 (True) else leave blank (False)

 

[Fluff]

Maybe

=IF(AND(B3="A",OR(C3="N",D3="N")),B4,"")