-
Notifications
You must be signed in to change notification settings - Fork 1
Math functions
Calculates the average of the supplied numbers. The function includes numeric values and boolean values (TRUE = 1, FALSE = 0).
Example: AVERAGE(2, 3, 4)
Rounds a number away from zero (ie. rounds a positive number up and a negative number down), to a multiple of significance.
Example: CEILING(22.35, 0.1)
Returns the cosine of the specified angle.
Example: COS(2)
Returns the hyperbolic cosine of the specified angle.
Example: COSH(2)
Returns number of numeric (dates included) values in the supplied list. If a value is a list, the values of that list will be counted as well.
This method behaves differently when it is supplied with values from an excel range or if its supplied directly with values via arguments (like the example below). Here the method ignores strings regardless if they contains dates or numbers. This is the same behaviour as when the values are supplied from an excel range.
Example: COUNT(1,2,{3,4})
Returns number of non-empty values in the supplied list. If a value is a list, the values of that list will be counted as well.
Example: COUNTA(1,2,'','a')
Returns a number raised to a given power
Example: EXP(4)
Rounds a number towards zero, (ie. rounds a positive number down and a negative number up), to a multiple of significance
Example: FLOOR(22.35, 0.1)
Returns the integer portion of the supplied value. The supplied value can be a decimal number or a string representation of a decimal value.
Example: INT(2.99)
Returns the logarithm of the supplied number.
Returns the base 10 logarithm of the supplied number.
Returns the largest value from a set of numerical values
Returns the largest value from a set of numerical values, but includes boolean values (TRUE=1, FALSE=0) and strings (always 0).
Returns the smallest value from a set of numerical values
returns the remainder of a division between two supplied numbers
Example: MOD(5,2)
Returns the PI constant
Example: PI()
Returns the result of the supplied number raised to the supplied power
Example: POWER(3, 3)
Returns a random number between 0.0 and 1.0.
Example: RAND()
Returns an integer random number within the supplied inteval.
Example: RANDBETWEEN(1,5)
Rounds a number up or down, to the supplied number of digits.
Example: ROUND(2.2, 0)
Returns the sine of the specified angle.
Example: SIN(2)
Returns the hyperbolic sine of the specified angle.
Example: SINH(2)
Returns the square root of the supplied number
Example: SQRT(9)
Returns the square root of the supplied number multiplied with PI.
Example: SQRTPI(9)
Calculates the standard deviation of the supplied set of values
Example: STDEV(1,2,3,4)
Calculates the population standard deviation of the supplied set of values
Example: STDEVP(1,2,3,4)
Performs a specified calculation on the supplied set of values.
Supported functions: 1-11 and 101-111 (the latter will ignore values from hidden cells).
Example: SUBTOTAL(1, 2, 3, 4)
(the function above will calculate the average of 2, 3 and 4)
Calculates the sum of the supplied set of values.
Calculates the sum of the values that matches the given criteria.
Returns the tangent of the specified angle.
Example: TAN(2)
Returns the hyperbolic tangent of the specified angle.
Example: TANH(2)
Variance in a sample
Example: VAR(1,2,3,4)
Variance in a population
Example: VARP(1,2,3,4)