How to use Filter function with and/or criteria

[helpneeded2]

I am new to the FILTER function and I have not been able to find a way to filter for data with multiple conditions.

Here is the syntax of my current filter, which does not appear to be correct syntax:

=FILTER(ALL!A2:BV26415,OR(ALL!AO2:AO26415="Not Rated",AND(ALL!AM2:AM26415="No",OR(ALL!AO2:AO26415="High",ALL!AO2:AO26415="Medium",ALL!AO2:AO26415="Low"))))

I am trying to filter my data only if 1 of these 2 conditions are met:
- Column AO data is = "Not Rated" (OR)
- Column AM is "No" AND Column AO is "High", "Medium" or "Low"

Can someone please advise if this is possible with the filter function.

Thank you.

 

[Fluff]

How about

=FILTER(ALL!A2:BV26415,(ALL!AO2:AO26415="Not Rated")+((ALL!AM2:AM26415="No")*((ALL!AO2:AO26415="High")+(ALL!AO2:AO26415="Medium")+(ALL!AO2:AO26415="Low"))))

 

[helpneeded2]

How about

=FILTER(ALL!A2:BV26415,(ALL!AO2:AO26415="Not Rated")+((ALL!AM2:AM26415="No")*((ALL!AO2:AO26415="High")+(ALL!AO2:AO26415="Medium")+(ALL!AO2:AO26415="Low"))))

Okay, I see how that is supposed to work now. Thank you for this.

 

[Fluff]

You're welcome & thanks for the feedback.