adding up formula

[jimjim001]

So, using google sheets for work. I am trying to get a formula that says either YES or NO, based on the following:

column E has a drop down option of (1,3,6,12 and 18)
columns J,K,L and M each have a drop down option of YES or NO

If column E has a 12 or an 18 selected, and then J,K,L and M all have a YES > then make column Q say YES
Otherwise, if any of those is not met, then make column M say NO

Image attached.

Any help would be greatly appreciated

TIA!

 

[etaf]

=IF ( AND ( J2 = "YES" , K2 = "YES", L2 = "YES", M2 = "YES" , OR ( E2 = 12 , E2 = 18 )) , "Yes", "No")
not sure what row this applies to , so change 2 to the row you want

 

[Peter_SSs]

So, using google sheets for work.

Is this question then about Google Sheets or is it for Microsoft Excel?

 

[jimjim001]

Is this question then about Google Sheets or is it for Microsoft Excel?I have

 

[jimjim001]

I have to use google sheets as the boss wants to use that. So in google sheets. But ive found this community really helpful and all the formula's typically carry over anyway!

 

[Joe4]

I think the question came up because you posted it in the wrong forum (you posted it in the "Excel Questions" forum).
I have moved it to the "General Discussion & Other Applications" forum. Note the description on that one:

General Discussion & Other Applications​

This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.

 

[Peter_SSs]

I think the question came up because you posted it in the wrong forum (you posted it in the "Excel Questions" forum).
I have moved it to the "General Discussion & Other Applications" forum.

Thanks for moving it Joe. Of course that's exactly why I asked.