Working with other functions (I)

Mathematic and trigonometric functions:

ABS (number) function

Returns the absolute value of a number, that is, the same number but with a positive sign

Example: =ABS(-34) returns 34

 

RAND () function

Returns a number between 0 and 1.

Example: =RAND() returns 0,345511245

 

COMBIN (number;number_chosen) function

Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.

Example:We have 20 students in the class and we want to form couples (of 2..), lets see how many possible combinations of couples we have, so we write =COMBIN(20;2) in cell A5, and we receive 190 as a result, that is, we can make 190 different different combinations of couples.

 

COS (number) function

Returns the cosine of an angle.

Example: =COS(0) returns 1

 

INT (number) function

Rounds a number down to the nearest integer

Example: =INT(10.45) returns 10, but if we write =INTEGER(-8.42) returns -9

 

EXP (number) function

Returns e raised to the power of a given number

Example: =EXP(1) returns 2,718281828

 

FACT (number) function

Returns the factorial of a number

Example: =FACT(5) returns 120 --> 1*2*3*4*5.

 

ROMAN(number,form)

Converts an arabic numeral to roman, as text.

 

The form parameter can have the following values.

0 or omitted - Classic

1 - More concise

2 - More concise

3 - More concise

4 - Simplified

TRUE - Classic

FALSE - Simplified

 

Example: =ROMAN(2049;0) returns MMXLIX, but if we write =ROMAN(2049;4) returns MMIL

 

PI () function

Returns the value of pi, precise to 15 digits

Example: =PI() returns 3,141592654

 

POWER (number;power) function

Returns the result of a number raised to a power indicated

Exampl: =POWER(2;5) returns 32

 

PRODUCT(number1;number2;...)

 

Multiplies its arguments

Example: =PRODUCT(20;4) returns 80

 

SQRT (number) function

Returns a positive square root

Example: =SQRT(25) returns 5

 

RESIDUO??? function(número;núm_divisor)

Returns the rest of the division

Example:: =RESIDUO(26;5) returns 1

Continue to the next page...

 
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.