To use AND and OR both together in google sheet query-CodePudding

Home > Back-end > To use AND and OR both together in google sheet query

To use AND and OR both together in google sheet query

Time：07-26

Is there any way I can use both operator i.e. AND and OR in the Google Sheets Query. For e.g.

"Select * where Col1 contains 'Yes' or Col2 contains 'Yes' and Col3 contains 'Please'"

CodePudding user response：

Try

"Select * where (Col1 contains 'Yes' or Col2 contains 'Yes') and Col3 contains 'Please'"

add parenthesis