Page 74 - Web_Application_v2.0_C12_Fb
P. 74
Function Description
It produces the square root of a positive integer.
SQRT(X)
E.g., =SQRT(9) = 3, =SQRT(2) = 1.414213562
It produces the value of X that is rounded to the number of digits specified by Y.
ROUND(X,Y)
E.g., =ROUND(12.234,2)= 12.23, =ROUND(32.67,0)=33
It produces the remainder of X divided by Y.
MOD(X,Y)
E.g., =MOD(11,2) = 1, =MOD(90,2) = 0
It produces the value of X raised to the power of Y.
POWER(X,Y)
E.g., =POWER(5,2)=25, =POWER(-5,0.5)=#NUM!
It multiplies all the given arguments.
PRODUCT(X,Y)
E.g., =PRODUCT(5,2,3) = 30, =PRODUCT(-5,6,0) = 0
Date and Time Functions
We can add the date and time in a cell. Built into LibreOffice Calc are a number of DATE and TIME functions
that can be used to do this.
Function Description
TODAY( ) Produces the current date; it contains no argument.
NOW( ) Produces the current date and time; it contains no argument.
Returns the year from a date value. E.g.
YEAR(“Date”)
=YEAR(DATE(2024,3,2))
Returns the month from a date value (1-12). E.g.,
MONTH(“Date”)
=MONTH(DATE(2024,3,2)) returns “3” for March.
Returns the day of the month from a date value. E.g.,
DAY(“Date”)
=DAY(DATE(2024,3,2))
Statistical Functions
Statistical Functions take numeric argument(s) and produce results accordingly. Following are the different
types of statistical functions:
Function Description
AVERAGE( ) Produces the average (mean) of the given arguments.
E.g.,=AVERAGE(10,20,30) will display 20
=AVERAGE(A1,A2,A3) Displays the average of the cells A1, A2 and A3
=AVERAGE(A1:A10) Displays the average of the cells from the range A1 to A10
MAX( ) Produces the largest value from the given range of cells.
E.g., =MAX(10,20,15,25) will display 25
=MAX(A1:A5) Displays the largest value from cell A1 to A5.
=MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and C4.
72 Touchpad Web Applications (Ver. 2.0)-XII

