IF WITH 2 CRITERIA

I'm looking to make a formula that will do the following:

search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO"

I included an image that hopefully clarifies this a little more.

in the image I show 3 "A"s in Column2, 2=YES and 1=NO in Column3...so therefore the formula would return a value of "NO"

Find more posts tagged with

Manufacturing

Construction

Formulas

Hi,

you could try to check if the count of "NO" is >0 for the range where Column2="A". This would look like :

"=IF(COUNTIF(COLLECT(COLUMN3:COLUMN3,COLUMN2:COLUMN2,"A"),"NO")>0,"YES","NO")"

Could this help?

Cheers,

Paul.

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…