Page 30 - TP_V5.1_C7_fb
P. 30

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
                          1  Type this                                             strings using cell reference.
                         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




                   28   Premium Edition-VII
   25   26   27   28   29   30   31   32   33   34   35