OR

Returns TRUE when at least one condition is true.

Syntax

OR(logical1, [logical2], ...)

Logical Functions.

=IF(OR(C2="Hold",B2>10000),"Review","Auto")

Returns Auto

Flags for review when either condition is true.

OR returns TRUE as soon as one condition matches, so a rule needing every condition met should use AND.