Page 218 - CA_165_V2.0_C9_Flipbook
P. 218
Operator Description Operator Description
: Reference operator (as in A2:A20) , ; Argument Separator
- Negation operator ^ Exponent
*,/ Multiplication, Division +,- Addition, Subtraction
& Text Concatenation >,<,>=,<=,<> Comparison operator
Mathematical Functions
These functions perform mathematical calculations on the specified arguments. Some mathematical
functions are:
Function Result (Considering a number as X)
It produces the sum of the numbers for a range of cells.
SUM(X;Y;...)
Eg. =SUM(C1:C4) (will produce the addition of cell from C1 to C4)
It produces the positive (absolute) value of a given integer.
ABS(X)
Eg. =ABS(-8) = 8, =ABS(4) = 4, =ABS(-3.7) = 3.7
It produces the integer value of a given integer.
INT(X)
Eg. =INT(12.54) = 12, =INT(-8.72) = -9
It produces the square root of a positive integer.
SQRT(X)
Eg. =SQRT(9) = 3, =SQRT(2) = 1.414213562
It produces the value of X that is rounded to the number of digits specified
ROUND(X;Y) by Y.
Eg. =ROUND(12.234;2) = 12.23, =ROUND(32.67;0) = 33
It produces the remainder of X divided by Y.
MOD(X;Y)
Eg. =MOD(11;2) = 1, =MOD(90;2) = 0
It produces the values of X raised to the power of Y.
POWER(X;Y)
Eg. =POWER(5;2) = 25, =POWER(-5;0.5) = #NUM!
It multiplies all the given arguments.
PRODUCT(X;Y)
Eg. =PRODUCT(5;2;3) = 30, =PRODUCT(-5;6;0) = -0
Notes
AUTOSUM (Σ) is a shortcut tool for adding the values of a range of Cells. To do so:
Select the range of cells to be added, click on the Autosum button (Σ) near formula bar. The sum is
displayed in the next cell.
216 Touchpad Computer Applications (Ver. 2.0)-IX

