O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Conducting a Sensitivity Analysis with Multiple Operations

Although the command name “Multiple Operations” is not particularly descriptive, this feature enables you to do a sensitivity analysis of data in a spreadsheet. In a nutshell, a sensitivity analysis allows you to place a function (or formula in a spreadsheet) and then view the different outcomes that are provided when you vary the input to the function. For example, you could use the function PMT, which uses the rate (for a monthly payment remember to divide the rate by 12 in the function), number of payments, and the principal on a loan, to create an analysis sheet that shows you the different payment amounts at different car prices. Since a sensitivity analysis allows you to vary two ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required