IIF(condition,true_value,false_value)
Returns true_value if a given condition evaluates to true, otherwise returns false_value.

INRANGE(value,start,end)
Returns true if a given value is between start and end.

ISNULL(value)
Returns true if a given value is null.