Formulas for ranges

Built-in formulas that operate on ranges:

contains

This formula gives you whether a range contains a certain value.