Page 47 - Plus_V2.2_C6_Flipbook
P. 47
Step 2: Type =CONCATENATE(A3,B3) function in the cell C3 to concatenate the first name and last
name.
Step 3: Press the Enter key from the keyboard.
Using Concatenate function
When you press the Enter key, first name and last name appear after concatenation.
Logical Functions
Functions Purpose
It checks whether the given condition met, and
IF(condition, returns value1 if the condition evaluates to true,
value1, value2) and returns value2 if the condition evaluates to
false.
Example: If Percentage > = 50, "Pass", "Fail"
Formulas and Functions in Excel 2016 45

