The logical operators AND and OR have been added to the formulas language. This will allow for writing more readable and expressive formulas:

// old way
IF(AND(foo, bar), "foo and bar were true")
IF(OR(foo, bar), "either foo or bar were true")

// new way
IF(foo AND bar, "foo and bar were true")
IF(foo OR bar, "either foo or bar were true")

The operators may also be written as && and || for those more used to this style from other languages.

These operators work in a manner similar to python, javascript and ruby so you can use them to quickly provide a fallback in cases where a value may be null:

// old way
DEFAULT(maybe_null_value, "value if null")

// new way
maybe_null_value || "value if null"