# Maths

To use a math expression, you need to use `{{#=}}`

:

## Mathematical operators

Operator | Description | Example | Example result |
---|---|---|---|

`+` | Additive operator / Unary plus | `1 + 3` | `4` |

`-` | Subtraction operator / Unary minus | `4 - 3` | `1` |

`*` | Multiplication operator | `2 * 3` | `6` |

`/` | Division operator | `6 / 4` | `1.5` |

`%` | Remainder operator (Modulo) | `5 % 3` | `2` |

`^` | Power Operators | `2 ^ 3` | `8` |

## Boolean operators

Boolean operators always result in a value of 1 or 0 (zero). Any non-zero value is treated as a *true* value. Boolean *not* is implemented by a function.

Operator | Description | Example | Example result |
---|---|---|---|

`=` | Equals | `2 = 2` | `1` |

`==` | Equals | `2 == 1` | `0` |

`!=` | Not equals | `2 != 1` | `1` |

`<>` | Not equals | `2 <> 2` | `0` |

`<` | Less than | `1 < 2` | `1` |

`<=` | Less than or equal to | `1 <= 1` | `1` |

`>` | Greater than | `1 > 2` | `0` |

`>=` | Greater than or equal to | `1 >= 2` | `0` |

`&&` | Boolean and | `1 && 0` | `0` |

`||` | Boolean or | `1 || 0` | `1` |

## Functions

Functions names are case insensitive.

Function | Description |
---|---|

NOT(expression) | Boolean negation, 1 (means true) if the expression is not zero |

IF(condition,value_if_true,value_if_false) | Returns one value if the condition evaluates to true or the other if it evaluates to false |

RANDOM() | Produces a random number between 0 and 1 |

MIN(e1,e2, ...) | Returns the smallest of the given expressions |

MAX(e1,e2, ...) | Returns the biggest of the given expressions |

ABS(expression) | Returns the absolute (non-negative) value of the expression |

ROUND(expression,precision) | Rounds a value to a certain number of digits, uses the current rounding mode; helpful with formatting numbers |

FLOOR(expression) | Rounds the value down to the nearest integer |

CEILING(expression) | Rounds the value up to the nearest integer |

LOG(expression) | Returns the natural logarithm (base e) of an expression |

LOG10(expression) | Returns the common logarithm (base 10) of an expression |

SQRT(expression) | Returns the square root of an expression |

SIN(expression) | Returns the trigonometric sine of an angle (in degrees) |

COS(expression) | Returns the trigonometric cosine of an angle (in degrees) |

TAN(expression) | Returns the trigonometric tangents of an angle (in degrees) |

ASIN(expression) | Returns the angle of asin (in degrees) |

ACOS(expression) | Returns the angle of acos (in degrees) |

ATAN(expression) | Returns the angle of atan (in degrees) |

SINH(expression) | Returns the hyperbolic sine of a value |

COSH(expression) | Returns the hyperbolic cosine of a value |

TANH(expression) | Returns the hyperbolic tangents of a value |

RAD(expression) | Converts an angle measured in degrees to an approximately equivalent angle measured in radians |

DEG(expression) | Converts an angle measured in radians to an approximately equivalent angle measured in degrees |

## Constants

Constant | Description |
---|---|

e | The value of e, exact to 70 digits |

PI | The value of PI, exact to 100 digits |

TRUE | The value one |

FALSE | The value zero |

NULL | The null value |