Available Math functions (www.excelfunctions.net) Basics + - * / Trigonometrie and other functions ABS // Returns the absolute value ACOS // Returns the Arccosine of a number ASIN // Returns the Arcsine of a number ASINH // Returns the Inverse Hyperbolic Sine of a number ATAN // Returns the Arctangent of a given number ATAN2 // Returns the Arctangent of a given pair of x and y coordinates CEILING // Rounds a number away from zero COS // Returns the Cosine of a given angle COSH // Returns the hyperbolic cosine of a number EXP // Returns e raised to a given power FLOOR // Rounds a number towards zero INT // Rounds a number down to the next integer LN // Returns the natural logarithm of a given number LOG // Returns the logarithm of a given number, to a specified base LOG10 // Returns the base 10 logarithm of a given number PI // Returns the constant value of pi POWER // Returns the result of a given number raised to a supplied power RAND // Returns a random number between 0 and 1 RANDBETWEEN // Returns a random number between two given integers SIGN // Returns the sign (+1, -1 or 0) of a supplied number SIN // Returns the Sine of a given angle SINH // Returns the Hyperbolic Sine of a number SQRT // Returns the positive square root of a given number SUM // Returns the sum of a supplied list of numbers TAN // Returns the Tangent of a given angle TANH // Returns the Hyperbolic Tangent of a given number TRUNC // Truncates a number towards zero Statistical (analog Excel) AVERAGE // Returns the average of the numbers provided AVERAGEA // Same as AVERAGE but treats booleans as 0 or 1 COUNT // Counts the number of numerical values COUNTA // Counts the number of non empty values COUNTBLANK // Counts the number of empty values COUNTIF // Returns the number of values that satisfy a given criteria MAX // Returns the largest value from a list of supplied numbers MAXA // Same as MAX but treats booleans as 0 or 1 MIN // Returns the smallest value from a list of supplied numbers MINA // Same as MIN but treats booleans as 0 or 1 STDEV // Returns the standard deviation of a supplied set of values STDEVA // Same as STDEV but treats booleans as 0 or 1 STDEVP STDEVPA VAR // Returns the variance of a supplied set of values VARA // Same as VAR but treats booleans as 0 or 1 VARP VARPA Text functions CHAR // Returns the character specified by the code number CODE // Returns a numeric code for the first character in a text string CONCATENATE // Joins several text items into one text item FIND // Finds one text value within another (case-sensitive) LEFT // Returns the leftmost characters from a text value LEN // Returns the number of characters in a text string LOWER // Converts text to lowercase MID // Returns a specific number of characters from a text string starting at the position you specify PROPER // Capitalizes the first letter in each word of a text value REPLACE // Replaces characters within text REPT // Repeats text a given number of times RIGHT // Returns the rightmost characters from a text value SEARCH // Finds one text value within another (not case-sensitive) SUBSTITUTE // Substitutes new text for old text in a text string T // Converts its arguments to text TEXT // Formats a number and converts it to text TRIM // Removes spaces from text UPPER // Converts text to uppercase VALUE // Converts a text argument to a number