Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 40 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 40

    Functions                        Purpose                                Example

                       MIN(range)            It returns the smallest value in the      Input: =MIN(16,21,18,7,13)
                                             given range.                              Output: 7

                       AVERAGE(range)        It gives the average of the given         Input: =AVERAGE(16,21,18,7,13)
                                             numbers in a range.                       Output: 15

                       COUNT(Number1,  It returns the count of the number of  Input: =COUNT(6,4,8,9,7)
                       Number 2, …) OR  given values or values in the selected  Output: 5
                       COUNT(range)          range.

                      Date Functions

                      Some of the date functions are given in the table below:

                                  Functions                          Purpose                          Example

                       DATE(YEAR, MONTH, DAY)             It returns the date in DD/MM/ Input: =DATE(2024,23,7)
                                                          YY format.                        Output: 23/7/2024

                       TODAY()                            It returns the current date of    Input: =TODAY()
                                                          the computer.                     Output: 7/23/2024

                       MONTH(TODAY())                     It returns the current month.     Input: =MONTH(TODAY())
                                                                                            Output: 7

                       YEAR(TODAY())                      It returns the current year.      Input: =YEAR(TODAY())
                                                                                            Output: 2024

                       DAY(TODAY())                       It returns the current day.       Input: =DAY(TODAY())
                                                                                            Output: 23

                       Clickipedia

                             The common functions like SUM, AVERAGE, MAX, MIN and COUNT
                            can be used by using the functions from the properties pane.

                            To use other functions, click on Insert → Function option.

                     38     Premium Edition-VII

| 35 36 37 38 39 40 41 42 43 44 45 |