Built-in Functions

Function NameDescription

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)

Last updated