I have a spreadsheet which I want to filter by a set formula.
If A2 <> "-" or A2 <> " " AND B2<>" " AND C2 <>" " "Review".
I have tried a number of ways to do this, including nested IF and did not get the answer I was hoping for.
I have attached an example of what I have tried to do with AND function.
I would be very grateful for any help.