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) |
Last updated