Page 65 - TechPluse_C6_Flipbook
P. 65
This is because Calc calculates the expression (20 + 20) within the parentheses first. It then
multiplies by 3. If you are unsure of the order in which Calc calculates, use parentheses even if
the parentheses aren’t necessary. Parentheses also make your formulas easier to understand.
FUNCTIONS
Functions are predefined formulas in Calc to perform both simple and complex calculations.
They accept arguments and return values. Arguments are input to functions. These values can be
number or text. The values are given in parenthesis. Return values display the function output.
Rules for using Functions
All Calc functions must begin with = sign
Function name must be a valid Calc name.
Function must be followed by opening and closing parenthesis.
Functions must contain an argument within it.
Type of Functions
LibreOffice Calc provides the following categories of functions:
Date & Time Functions: Calculates the day, month and year in a date and the hour, minute
and second in a particular time.
Logical Functions: Evaluates conditions such as Y < 3 and give the result as true or false.
Mathematical Functions: Calculates the square root or absolute value of a number, product
of numbers, etc.
Statistical Functions: Calculates the maximum, minimum, average, etc. of a set of numeric data.
Text Functions: Performs a number of operations on strings (i.e. a collection of characters
like 'hello', 'friend', 'computer', etc.) such as finding the length of a string, joining two strings,
searching for one string inside another etc.
Let us discuss these categories in detail.
Mathematical Functions
Functions Purpose Example
SUM`(Number1, Number It returns the sum of given Input: =SUM(3,6,9,12)
2, …) OR SUM(Range) numbers or a range. Output: 30
PRODUCT(Number1, It multiplies the given values or a Input: =PRODUCT(2,5,9)
Number 2, …) OR range of cells. Output: 90
PRODUCT(Range)
MOD (Dividend, Divisor) It returns the remainder after a Input: =MOD(15,7)
dividend is divided by the divisor. Output: 1
Formulas, Functions and Charts in Calc 63

