You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/manual/functions.qmd
+4Lines changed: 4 additions & 0 deletions
Original file line number
Diff line number
Diff line change
@@ -17,9 +17,12 @@ The following built-in functions are available:
17
17
| COSH(Number) | Hyperbolic cosine of *Number*. |
18
18
| COT(Number) | Cotangent of *Number*. |
19
19
| EXP(Number) | Euler to the power of *Number*. |
20
+
| EVEN(Number) | Returns *Number* rounded up to the nearest even integer.<br>\linebreak *Number* is always rounded away from zero (e.g., `EVEN(-3)` = -4). |
20
21
| FAC(Number) | Returns the factorial of *Number*. The factorial of *Number* is equal to 1\*2\*3\*...\**Number*|
21
22
| FACT(Number) | Alias for `FAC()`|
22
23
| FLOOR(Number) | Returns the largest integer not greater than *Number*.<br>\linebreak `FLOOR(-3.2)` = -4<br>\linebreak `FLOOR(3.2)` = 3 |
24
+
| ISEVEN(Number) | Returns true if *Number* is even, false if odd. |
25
+
| ISODD(Number) | Returns true if *Number* is odd, false if even. |
23
26
| LN(Number) | Natural logarithm of *Number* (base Euler). |
24
27
| LOG10(Number) | Common logarithm of *Number* (base 10). |
25
28
| MIN(Number1, Number2, ...) | Returns the smallest value from a specified range of values. |
@@ -29,6 +32,7 @@ The following built-in functions are available:
29
32
| NAN | Returns an invalid value (i.e., Not-a-number). |
30
33
| NCR(Number, NumberChosen) | Alias for `COMBIN()`. |
31
34
| NPR(Number, NumberChosen) | Alias for `PERMUT()`. |
35
+
| ODD(Number) | Returns *Number* rounded up to the nearest odd integer.<br>\linebreak *Number* is always rounded away from zero (e.g., `ODD(-4)` = -5). |
32
36
| PERMUT(Number, NumberChosen) | Returns the number of permutations for a given number (*NumberChosen*) of items that can be selected *Number* of items. A permutation is any set of items where order is important. (This differs from combinations, where order is not important). |
33
37
| POW(Base, Exponent) | Raises *Base* to any power. For fractional exponents, *Base* must be greater than 0. |
0 commit comments