Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 40 - logicode 2609 C6
P. 40

    2  Click on the Formulas tab.

                        3  Click on the
                       Insert  Function
                       command.

                                                                                                            1  Select the
                                                                                                           cell where you
                                                                                                           want the  result
                                                                                                           to be displayed.

                                         4  Select the Logical option from the
                                        Or select a category drop-down list.

                                                                                  7  Fill the required details. Now you will notice
                                                                                 that the condition is evaluated to be true and
                                                                                 the result is displayed below the IF frame.

                        5  Select the
                       IF function.

                                                    6  Click on the OK button.                     8  Click on the OK button.

                      In the Logical test box, provide a condition that evaluates to be true or false. In the Value_if_true
                      box, provide a value that you want to display in the active cell if the condition evaluates to be true.

                      Similarly, in the Value_if_false box, provide a value that you want to display in the active cell if
                      the condition evaluates to be false.

                           Tick ( ) if you know this.
                           ▶   The IF function allows us to check a condition and take action based on the results.

                           ▶  The SUM function calculates the total of a given set of values.

                       38   Premium Edition-VI

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