openoffice calculate difference in a cell

The Multiple Operations tool can use any number of formulas, but only one or two variables. The second array is then filled with the results of using each alternative value in place of the original values. Once the alternative values are created, you use the Multiple Operations tool to specify which formulas you are using, as well as the original values used by the formulas. It is created by entering a list of alternative values for one or two of the original values. The first array contains the original or default values and the formulas applied to them.

To use the Multiple Operations tool, you need two arrays of cells. Although this 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. Instead, the Multiple Operations tool creates a formula array: a separate set of cells showing the results of applying the formula to a list of alternative values for the variables used by the formula. Unlike a scenario, the Multiple Operations tool does not present the alternate versions in the same cells or with a drop-down list. Like scenarios, Data > Multiple Operations is a planning tool for “what if” questions.

Openoffice calculate difference in a cell