Mathematics
Mathematical statistical, trigonometric and hyperbolic functions.
See all of the Functions.
| Abs | Returns the absolute value of a number. |
| ACos | Computes the arc-cosine, or inverse cosine, of a number. |
| ACosh | |
| Alea | |
| AleaGauss | |
| ArcCos | |
| ArcCosh | |
| ArcSin | |
| ArcSinh | |
| ArcTan | |
| ArcTanh | |
| AreNumbers | Determines whether or not a series of values are numbers. |
| Arrondi | |
| ASin | |
| ASinh | Returns the inverse hyperbolic sine of a number. |
| ATan | |
| ATanh | |
| Average | Calculates the arithmetic mean of the values in a list of values, range(s), or list(s). |
| Ceil | Returns the smallest integer greater than or equal to a number. |
| Cos | |
| Cosh | |
| Count | Counts the number of non-empty numerical cells in a value set. |
| CountEqual | Counts the number of values in a value set that are equal to a specific value. |
| CountIf | Counts the number of values in a value set that meet a condition. |
| CountVal | Counts the number of non-empty cells in a value set. |
| Degrees | |
| Degrees | Converts radians into degrees. |
| DegToRad | |
| EcarType | |
| EcarTypeP | |
| Ent | |
| EstNum | |
| Etendue | |
| Exp | |
| FKhi2 | |
| Floor | Returns the largest integer less than or equal to a number. |
| FormatFloat | Converts a floating-point value to a string and specifies the format. |
| Frac | |
| GaussRand | |
| Haversine | Computes the distance on a sphere. |
| Int | |
| InverseFKhi2 | |
| IsNumber | Determines whether or not a value is a number. |
| ListPolynomial | Applies a polynomial to the items of a list. |
| ListSign | Computes the sign of values in a list. |
| Ln | |
| Log | |
| Log10 | |
| Max | Calculates the (numerical) maximum out of all of the values in a list of values, ranges and/or lists. |
| Median | |
| Mediane | |
| Min | Calculates the (numerical) minimum out of all of the values in a list of values, ranges and/or lists. |
| Moyenne | |
| Nb | |
| NbSi | |
| NbVal | |
| PI | |
| Plafond | |
| Plancher | |
| Radians | Converts degrees into radians. |
| RadToDeg | |
| Rand | |
| Range | |
| RangeRatio | |
| Round | Performs rounding to the nearest integer or to an optional number of decimal places. |
| Sign | Returns a number's sign, in the form of -1, 0 or +1. |
| Sin | |
| Sinh | |
| Somme | Alias of Sum. |
| SommeSi | |
| Sqrt | Computes the square root of a positive number. |
| StdDev | |
| StdDevP | |
| Sum | Calculates the numerical sum of the values in a list of values, ranges and/or lists. |
| Sum2 | Calculates the numerical sum of the squared values in a list of values, ranges and/or lists. |
| SumIf | |
| Tan | |
| Tanh |