Page 28 - TP_Pro_V5.1_Class6
P. 28
LEFT(text, It returns the specified number of characters Input: =LEFT("Track",3)
num_chars) from the start of the text string. Output: Tra
RIGHT(text, It returns the specified number of characters Input: =RIGHT("Track",3)
num_chars) from the end of the text string. Output: ack
Input: =LEN("Track")
LEN(text) It returns the length of the text string.
Output: 5
Input: =UPPER("Track")
UPPER(text) It converts the text string into uppercase.
Output: TRACK
Input: =LOWER("Track")
LOWER(text) It converts the text string into lowercase.
Output: track
For example, CONCATENATE () function:
2 Type =CONCATENATE(A1,B1)
function to concatenate two
strings using cell reference.
1 Type this data.
STATISTICAL AND LOGICAL FUNCTIONS
Some statistical and logical with their examples are given below:
Function Purpose Example
It returns the largest value in the given range Input: =MAX(4,16,12,9)
MAX(range)
of numbers. Output: 16
It returns the smallest value in the given range Input: =MIN(4,16,12,9)
MIN(range)
of numbers. Output: 4
Input: =AVERAGE(10, 12, 14)
AVERAGE(range) It returns the average of a range of numbers.
Output: 12
It returns the count of the number of values in Input: =COUNT(4,8,12)
COUNT(range)
the selected range. Output: 3
It checks whether the given condition is met, Percentage = 80
IF(condition, value1, and returns value1 if the condition evaluates Input: =IF(Percentage >= 50,
value2) to true, and returns value2 if the condition “Passed”, “Failed”)
evaluates to false. Output: Passed
26 Pro (V5.1)-VI

