Page 89 - IT-802_class_12
P. 89
3.10.1 Mathematical Functions
These functions perform mathematical calculations on the specified arguments. Some mathematical functions are:
Function Result (Considering a number as X)
SUM(X;Y,...) It produces the sum of the numbers for a range of cells. E.g., =SUM(C1 ...C4) or
=SUM(C1:C4) This will produce the addition of the cells from C1 to C4.
ABS(X) It produces the positive (absolute) value of a given integer.
E.g. =ABS(-8) returns 8, =ABS(4)=4, =ABS(-3.7) returns 3.7
INT(X) It produces the integer value of a given integer.
E.g. =INT(12.54) returns 12, =INT(-8.72) returns -9
SQRT(X) It produces the square root of a positive integer.
E.g. =SQRT(9) returns 3, =SQRT(2) returns 1.414213562
ROUND(X;Y) It produces the value of X that is rounded to the number of digits specified by Y.
E.g. =ROUND(12.234;2) returns 12.23, =ROUND(32.67;0) returns 33
MOD(X;Y) It returns the remainder of X divided by Y.
E.g. =MOD(11;2) returns 1, =MOD(90;2) returns 0
POWER(X;Y) It produces the value of X raised to the power of Y.
E.g. =POWER(5;2) returns 25, =POWER(-5;5) returns -3125
PRODUCT(X;Y) It multiplies all the given arguments.
E.g. =PRODUCT(5;2;3) returns 30, =PRODUCT(-5;6;0) returns 0
LOG(n;b) It calculates the log of a number n to base b.
SIN(n), COS(n), TAN(n) It calculates the sine, cosine, and tangent of n.
RANDBETWEEN(f;l) It returns a random number between f and l.
QUOTIENT(a;b) It calculates the integer quotient of division a/b.
ICT Skills-IV 87

