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.
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 ...