IF function question

[Mikalas]

Hello, I'm still learning IF functions and have a question to see if this is possible. I have 2 fields that can have a Yes, No, N/A response to determine if supplemental criteria for a project was met. I'm trying to get a response of Yes if the field is "Yes" or "N/A" in both of these columns as I couldn't figure out how to break this down. I think I've come up with the right function for this but if I drag down the formula, I get all "YES" in the blank fields. How can I make this so that I don't get "Yes" in the blank fields when dragged down if the data has not been input yet? This is my current formula to get the Yes/No response: =IF(AND(NOT(B4="No"),NOT(C4="No")),"Yes","No"). Or is there a way to to combine functions to say if B=Yes and C=Yes then D is Yes (true) OR if B=N/A and C=N/A then D=N/A OR if B=No and C = No then D= No and also still have the "blank" response if I drag down the function? Here is a screen shot of the portion of my sheet that I'm trying to fix:

View attachment 88787

I'm sure this is basic for most of you but thank you in advance from a new learner!

Michelle

 

[Fluff]

How about

=if(sum(countifs(b4:c4,{"Yes","N/A"}))=2,"yes","no")

 

[Mikalas]

How about

=if(sum(countifs(b4:c4,{"Yes","N/A"}))=2,"yes","no")

Thank you for your suggestion. I will try this!

 

[Fluff]

Ok Let us know how it goes.