Unit 4. Formulas and functions (VII)

 Other functions.

Besides the previousely mentioned functions, a wide range of functions exist for different categories, all of which can be of great assistance.

In this chapter we will cover a few of theses functions, all classified by category.

 Function Description See detail Mathematics and trigonometric functions ABS(number) Returns the absolute value of a number RAND() Returns a number between 0 and 1 COMBIN(number,number_chosen) Returns a number of combinations for a determined number of elements COS(number) Returns the cosinus of an number INT(number) Rounds the number off to the nearest integer EXP(number) Performs the calculation to elevate "e" to the power of a determined number FACT(number) Returns the factorial of a number ROMAN(number,form) Converts an arabic numeral to roman, as text. PI() Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits. POWER(number;power) Returns the result of a number raised to a power. PRODUCT(number1;number2;...) Multiplies all the numbers given as arguments and returns the product SQRT(number) Returns a positive square root. MOD(number;divisor) Returns the rest of the division Statistics functions HARMEAN(number1;number2;...) Reurns the harmonic mean of a data set MAX(number1;number2;...) Returns the maximum value of a list of values MIN(number1;number2;...) Returns the maximum value of a list of values MEDIAN(number1;number2;...) Returns the median of the given numbers. MODE(number1;number2;...) Returns the most frequently occurring, or repetitive, value in an array or range of data. AVERAGE(number1;number2;...) Returns the average (arithmetic mean) of the arguments. VAR(number1;number2;...) Estimates variance based on a sample. LARGE(array;k) Returns the k-th largest value in a data set SMALL(array;k) Returns the k-th smallest value in a data set Logical functions FALSE() Returns the logical value FALSE TRUE() Returns the logical value TRUE IF(logical_test,value_if_true,value_if_false) Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. NOT(logical_value) Reverses the value of its argument. AND(logical_value1;logical_value2;...) Returns TRUE if all its arguments are TRUE OR(logical_value1;logical_value2;...) Returns TRUE if any argument is TRUE Information functions ISBLANK(value) Returns TRUE if the value is blank ISERR(value) Returns TRUE if the value is any error value except #N/A ISLOGICAL(value) Returns TRUE if the value is a logical value ISNONTEXT(valor) Returns TRUE if the value is not text ISTEXT(value) Returns TRUE if the value is text ISNUMBER(value) Returns TRUE if the value is a number TYPE(value) Returns a number indicating the data type of a value

 You can practise some of the functions explained here in the Exercises on other functions.
 If you want to know how to install and use the anaylsis toolpack to master more functions clic here .

dth="42%">
 Page. 4.7
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.