Built-in Functions

Function Name	Description
abs	Returns the absolute value of a number. The absolute value of a number is the number without its sign.
sqrt	Returns the square root of a positive number.
pow	Returns a number raised to a power. Takes two arguments: the base number and the exponent.
exp	Returns "e" raised to the power of a number. Takes one argument, the exponent.
log	Returns the logarithm of a number to the specified base. Takes two arguments: the number and the base. The default base is 10.
ln	Returns the natural logarithm of a number. Takes one argument, the number.
round	Rounds a number to the nearest integer.
floor	Rounds a number down to the nearest multiple of a significance value. Takes two arguments: the number and the significance.
ceil	Rounds a number up to the nearest multiple of a significance value. Takes two arguments: the number and the significance.
sin	Returns the sine of an angle. Takes one argument: the angle in radians
cos	Returns the cosine of an angle. Takes one argument - the angle in radians.
tan	Returns the tangent of an angle. Takes one argument - the angle in radians.
asin	Returns the inverse sine of a number. Takes one argument - the number
acos	Returns the inverse cosine of a number. Takes one argument - the number.
atan	Returns the inverse tangent of a number. Takes one argument - the number.
atan2	Returns the inverse tangent of x and y coordinates. Takes two arguments: x and y values.
sum	Adds values. It can take a range of cells or multiple arguments of values to add.
max	Returns the maximum value from a range of values. Takes one or more arguments of values.
min	Returns the minimum value from a range of values. Takes one or more arguments of values.
if	The "IF" function is used to test a condition and return one value if the condition is met and another value if the condition is not met. The syntax is: =if(logical_test, value_if_true, value_if_false)