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 .

  Theme 4 exercises

 

Theme 4 Theory evaluation test



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.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.