Page 204 - CA 165 ver 1.0 Class 9
P. 204
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), 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.
202 Touchpad Computer Applications-IX

