Page 29 - Trackpad_V1_Book 6_Flipbook
P. 29

For example, CONCATENATE () function:


                                                                                   2  Type =CONCATENATE(A1,B1)
                                                                                  function to concatenate two
                                                                                  strings using cell reference.





                                              1  Type the following data.


                 LOGICAL FUNCTIONS

                 Some logical functions with their examples are given below.



                       Function                           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

                                                                                        Input: =AVERAGE(10, 12, 14)
                  AVERAGE(range)         It returns the average of a range of values.
                                                                                        Output: 12

                                         It  checks  whether the  given  condition  is  Percentage = 80
                  IF(condition,          is met, and returns value1 if the condition  Input: =IF(Percentage >=
                  value1, value2)        evaluates to true, and returns value2 if the  50, “Passed”, “Failed”)
                                         condition evaluates to false.                  Output: Passed


                 For example, MAX () function:








                                                                                      2  Type =MAX(C5:F5)
                                                                                     function in the cell G5.







                              1  Type the following data.

                 Now press  the  Enter key  and  maximum  marks appear  in cell  G5. Similarly,  we can find the

                 minimum marks by using the MIN() function.




                                                                                 Formulas and Functions in Excel 2010  27
   24   25   26   27   28   29   30   31   32   33   34