This chapter provides instructions on working with formulas, including comprehensive descriptions of PlanMaker's arithmetic functions:
The chapter consists of the following sections:
▪Formula basics
| The first section provides basic information on formulas. |
▪Entering formulas
| This section provides information on entering formulas in cells. |
▪Relative versus absolute cell references
| This section explains the difference between relative cell references (like =A1) and absolute cell references (like =$A$1) in formulas. |
▪External cell references
| The next section is about external cell references in formulas. These are cell references that refer to cells in a different file. |
▪Error values
| If a formula results in an error, an error value is displayed instead of the result. This section provides information on error values. |
▪Working with arrays
| This section provides instructions on working with arrays and array formulas. |
▪Working with database functions
| This section provides information on database functions such as DCount, DSum, etc. |
▪Functions from A to Z
| This section contains comprehensive descriptions of PlanMaker's arithmetic functions. |
Tip: A short introduction to working with formulas is also provided in chapter The PlanMaker tour.