Functions
AND
True if all arguments are true
Try it
When to use it
When should I use AND instead of OR?
Use AND when every condition must be true; use OR when any single condition being true is enough.
How do I combine AND with IF?
Wrap AND in the IF test, so the IF returns its true result only when all the AND conditions hold.
Use cases
Check a value falls within a range
Gate an outcome on all rules passing
Used in
Syntax
AND(value1,...)