Page 47 - Plus V4 with Adobe class 6
P. 47

Logical Functions

            Logical functions are used to test whether condition is true or false.

                Functions                              Purpose                                   Example

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

            Let us use the logical functions in Excel.

            Perform the following steps to use the logical functions:





                    Type  the  given
                1   data in the  Excel
                    worksheet.









                                            2   Type =MAX(B3:F3) function in the cell G3 to find
                                                the maximum marks and press Enter key.

            When you press the Enter key, the maximum marks appear in the cell G3. Using the AutoFill feature find the
            maximum marks of each student. Similarly, we can find the minimum marks by using the MIN() function.

            Date and Time Functions

            Date and Time functions are used to work or system's date and time.


                 Functions                            Purpose                                  Example

                                                                                    Input: =TODAY()
            Today()               It returns the current date.
                                                                                    Output: 7/23/2019
                                                                                    Input: =MONTH(TODAY())
            Month(Today())        It returns the current month.
                                                                                    Output: 7
                                                                                    Input: =YEAR(TODAY())
            Year(Today())         It returns the current year.
                                                                                    Output: 2019
                                                                                    Input: =DAY(TODAY())
            Day(Today())          It returns the current day.
                                                                                    Output: 23

                                                                                    Input: = NOW()
            NOW()                 It returns the current system date and time.
                                                                                    Output: 21-05-2020 11:24





                                                                          #Charts, Formulas and Functions in Excel  45
   42   43   44   45   46   47   48   49   50   51   52