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
   42   43   44   45   46   47   48   49   50   51   52