Using formulas

This is the real heart of the spreadsheet. You can use formulas to add, subtract, multiply, and divide the numbers in your spreadsheet. For example, you can:

With formulas, you can design spreadsheets that help you to explore "what if" possibilities. What happens to your profits if expenses creep up 9%? What if the payments on a new car stretch over 48 months instead of over 24? This "what if" analysis is a vital component of business and financial planning.

The following sections show you how to work with formulas in Ability. You will also need to refer to the sections under Function reference.

See:

What is a formula?

How to enter a formula

Clearing formulas

Automatic totals