AND, OR and NOT

Combine or reverse logical tests for more precise decisions.

Practical example

=IF(AND(B2="Active", C2>0), "Include", "Exclude")

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.