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)