**Released November 30, 2023**

Today's update includes a large number of new formula functions including the long awaited FIND! **For examples or the full list of our available functions and operators, check out ****this shared view****.**

**FIND()**

Returns a number that is the offset of the matched string’s first instance. If no match is found, returns -1

**Syntax:**`FIND(String to Find, Where to Search, Start Position, End Position)`

**RFIND()**

Returns a number that is the offset of the matched string’s last instance. If no match is found, returns -1

**Syntax:**`RFIND(String to Find, Where to Search, Start Position, End Position)`

**FLOOR()**

Returns the rounded-down value of the specified number to the nearest multiple of the given significance.

**Syntax:**`FLOOR(Number, Significance)`

**MID()**

Extracts a substring from a text string based on specified start and length parameters.

**Syntax:**`MID(Where to Search, Start Position, Length)`

**CEILING()**

Returns the rounded-up value of the specified number to the nearest multiple of the given significance.

**Syntax:**`CEILING(Number, Significance)`

**ODD()**

Returns the nearest odd integer greater than or equal to the specified number.

**Syntax:**`ODD( Number )`

**EVEN()**

Rounds a number up to the nearest even integer.

**Syntax:**`EVEN(Number)`

**ROUNDUP()**

Returns the rounded-up value of the specified number to the specified number of digits.

**Syntax:**`ROUNDUP(Number, Digits)`

**ROUNDDOWN()**

Returns the rounded-down value of the specified number to the specified number of digits.

**Syntax:**`ROUNDDOWN(Number, Digits)`

**NUMBER()**

While an existing function, this has been improved to now support precision.

**Syntax:**`NUMBER(Expression, Precision)`