<< Click to Display Table of Contents >> Formula basics

If you want to perform a calculation in PlanMaker, first place the cell frame on the cell where the result should appear. Then type the desired calculation into this cell.

Important When typing a formula, you must always start with an equals sign =, otherwise PlanMaker will consider your input as text or numerical values.

Formulas can be composed of the following components:

▪Fixed values (e.g., numbers or text)

▪Cell references (e.g., A1 or D2:D3)

▪Arrays (see also Working with arrays)

▪Arithmetic operators (e.g., + or -, see also Operators in formulas)

▪Arithmetic functions (e.g., SUM)

The result of a calculation can represent both a final value and an intermediate result, because each cell that contains the result of a calculation can be reused in another cell.

For example, a valid formula can look like this:

= 67 + (A3 * Sum(B1:C5))