Page 51 - KEC Khaitan C6 Flipbook
P. 51

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.







                                                                                         Advanced Features of Excel  49
   46   47   48   49   50   51   52   53   54   55   56