Page 24 - Trackpad_ipro 4.1_Class8
P. 24
Text Functions: These functions are used for manipulating text strings, such as combining,
trimming, changing the case of text, etc.
Logical Functions: These functions are used to perform logical tests and return logical values
(TRUE or FALSE).
Date and Time Functions: These functions help work with dates and times, allowing users to
extract and manipulate date and time information.
Lookup and Reference Functions: These functions are used to search for and return
information from a specific range or table.
Financial Functions: These functions are used for financial calculations, such as those
involving interest rates, loan payments, investments, depreciation, etc.
Information Functions: These functions return information about the data or the format,
location, or content of a cell.
Mathematical Functions
Function Purpose Example
Adds up all the numbers in a Input: =SUM(4,8,12,16)
SUM(range)
specified range Output: 40
Multiplies the numbers in a specified Input: =PRODUCT(4,2,8)
PRODUCT(range)
range Output: 64
Returns the remainder after dividing Input: =MOD(8,5)
MOD(number, divisor)
the number by the divisor Output: 3
Returns the square root of the given Input: =SQRT(81)
SQRT(number)
number Output: 9
Rounds the number to the nearest Input: =INT(14.25)
INT(number)
integer Output: 14
Returns the result of the number Input: =POWER(5,3)
POWER(number, power)
raised to the given power Output: 125
ROUND(number, Returns a number after rounding it Input: =ROUND(35.666,2)
number_of_digits) to the specified digits Output: 35.67
Returns the number of absolute Input: =ABS(-25)
ABS(number)
value of the given number Output: 25
Tech
Funda
In functions, we can also use the cell address in place of the values.
22 iPro (Ver. 4.1)-VIII

