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

