Page 170 - IT 402 v2.0 class 10
P. 170

Multiple Operations

         ike scenarios  Multiple Operations is also a planning tool for  what-if   uestions.  nlike Scenario  Multiple
        Operations tool does not present the alternative versions in the same cells or with a drop-down list. Instead
        the Multiple Operations tool creates a formula array which is a separate set of cells that give all the alternative
        results for the formulas used.  lthough the tool is not listed among the functions  it is really a function that
        acts on other functions  allowing you to calculate different results without having to enter and run them
        separately.
         o use the Multiple Operations tool  you need two arrays of cells:

           he first array contains the original or default values and the formulas applied to them.  he formulas must
           be in a range.
           he second array is the formula array. It is created by entering variables which are alternative values for one
           or two original values.
        Example:

         et s say        ublisher publishes a book whose selling price is `      cell      manufacturing

        cost of each book is `  5  cell      in addition to fixed cost of ` 5      per year  cell    .
         e can calculate profit made by the  ublisher in a year if they sell      books and profit for different sale of
         uantities that are  5           5           5   using multiple operations.

        Step 1:   o calculate the profit  enter the formula       -   -   in cell   5

        Step 2:  In column    enter expected   nnual Sale Figure .
        Step 3:  Select the range    :   .  his will select the values in column   and empty cells of column  .

        Step 4:   lick on   ata  menu and then select  Multiple Operations  option.





















                                                                             ‘Multiple operations’
                                                                            dialog box appears on
                                                                                 the screen.
















         168       Touchpad Information Technology-X
   165   166   167   168   169   170   171   172   173   174   175