Supported Maths Symbols

SymbolUseResultExplanationVersion
+2+35Addition Operator
3-21Subtraction Operator
/4/22Division operator 
*4*28Multiplication Operator 
pipi3.14Math constant pi
ee2.71Math constant e
modmod(3,2)1Modulus Operator 
floorfloor(5.95)5Returns the largest integer less than or equal to a given number.
roundround(5.5)6 Returns the value of a number rounded to the nearest integer.
minmin(4,3,5,36)3Returns the number with the lowest value.
maxmax(4,3,5,36)36Returns the number with the highest value.
avgavg(10,20,60)30 Its value can be obtained by calculating the sum of all the values in a set and dividing the sum by the number of values.
absabs(-3)3Returns the absolute value of a number
randomrandom(100,999)e.g: 342Returns a random number
sqrtsqrt(16)4Returns the square root of a number
sinsin(0)0Returns the sine of a number.
coscos(o)1 Returns the cosine of the specified angle, which must be specified in
ifif(1>3,1,2)2It allows you to make logical comparisons between a value and what you expect.pro
switchnumber =21
switch(number,10,2,20,30,4)
4The function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. pro
powpow(2,3)8Power function with two operator pro
daysdays(2022-12-20,2021-11-06)409Days Between Two Datespro
monthsmonths(2022-12-20,2021-11-06)13Months Between Two Datespro
yearsdays(2022-12-20,2021-11-06)1Years Between Two Datespro