Page 27 - iPlus_Ver_2.0_class_8
P. 27
When you press the Enter key, the first name and last name appear after concatenation.
3 Type =UPPER(A3) function to convert the First
Name into uppercase and press the Enter key.
When you press the Enter key, the first name appears in uppercase.
4 Type =LOWER(A3) function to convert the first
name into lowercase and press the Enter key.
When you press the Enter key, the first name appears in lowercase.
Logical Functions
Functions Purpose Example
It returns the largest value in the given Input: =MAX(4,16,12,9)
MAX(range)
range. Output: 16
It returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range. Output: 4
It returns the average of the given Input: =AVERAGE(12,3,6)
AVERAGE(range)
numbers in a range. Output: 7
It checks whether the given condition is Percentage = 80
IF(condition, met, and returns value1 if the condition Input: =IF(Percentage >= 50,
value1, value2) evaluates to true, and value2 if the “Passed”, “Failed”)
condition evaluates to false. Output: Passed
Let us use the logical functions in Excel.
25
Spreadsheet—Functions and Charts

