I need a formula to return the value "YES" in a cell if all of the following is true : L2= “YES”, P2= “YES”, Q2= “Complete”, S2= “YES”. Otherwise it should return the value "NO"
I need a formula to return the value "YES" in a cell if all of the following is true : L2= “YES”, P2= “YES”, Q2= “Complete”, S2= “YES”. Otherwise it should return the value "NO"
Last edited by Coubs3; 04-01-2014 at 10:39 AM.
Try this:
=IF(AND(L2=“YES”, P2=“YES”, Q2=“Complete”, S2=“YES”),"YES","NO")
May be this.........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
@ minnesotaart
In your formula, there are extra spaces in the logical condition, so it will produce #Name? error.
I tried this in two different cells. The first cell has data validation set up in it so YES and NO are the only options with NO being the default value in there already. I received an error that says "The value you entered is not valid. A user has restricted values that can be entered into this cell."
In the second cell there is no formatting or data validation applied to it and i received and "Invalid Name Error."
You are correct. I posted in a hurry...
=IF(AND(L2="Yes",P2="Yes",Q2="Complete",S2="Yes"),"Yes","No")
Winner. Thanks!
slightly shorter
=IF(L2&P2&Q2&S2="yesyescompleteyes","yes","no")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks