O'Reilly logo

iWork for Mac OS X Cookbook by Alexander Anichkin

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

Setting and using formulas in financial documents

This recipe shows how formulas work to make automatic calculations in common financial documents.

Numbers include formulas for advanced accounting and scientific calculations. However, in common daily use, we are more likely to do straightforward sums and calculate percentages to manage our home budgets or small businesses.

Let's see how to apply Numbers formulas to calculate VAT as a percentage of the sum of goods and services. Mastering this type of calculation will be useful when dealing with income tax, interest, trade discounts, and so on.

Getting ready

We will be using the Numbers Invoice template. Open it from File | New from Template Chooser.

The template has an invoice table that is already ...

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