Complex And Or formula combo

[EricBWS]

I am looking to combine and And and an Or Formula and I am having a little difficulty getting the whole thing to work.

I am wanting to combine.

OR(Any([Related Machine Cleanings By TDS Formula][TDS Reading]) > 45,(AND(HOUR(
TODAY() -
MAX([Related Machine Cleanings][Date])

with

And(Not(Contains([Company Name], "School")),(Not(Contains([Company Name],"Warehouse"))),(Not(Contains([Company Name],"Repair"))),Not(Contains([Company Name], "Test")))

[TeeSee1 · Accepted solution]

Not sure where you are struggling..

If you want to OR 'combine' then do

 OR( OR(...), AND(...) )

and if you want AND 'combine' then do

 AND( OR(...), AND(...) )

You can embed conditional expressions within conditional expressions with no issues. OR maybe I am missing something.

[EricBWS]

Super weird, yesterday I could not get it to go past this first and, tried again today and it took it.

[jaichith]

In first part of the expression, AND needs 2 arguments. It is not there please check. 

AND is used when all conditions should be met.

OR is used when anyone condition should be met.