Formula basics |
  
|
Formula basics |
|
If you want to perform a calculation in Calculate, first place the cell frame on the cell in which you want the result to appear. Then type the desired calculation into this cell.
Important When you enter a formula, you must always type an equal sign = first, as Calculate will consider your input as text or a numerical value otherwise.
Formulas can be composed of the following components:
▪Fixed values (for example, a number or text)
▪Cell references (for example, A1 or D2:D3)
▪Arrays (see also Working with arrays)
▪Arithmetic operators (for example, + or -, see also Operators in formulas)
▪Arithmetic functions (for example, SUM)
The result of a calculation can represent both a final value and an intermediate result because any cell that contains the result of one calculation can be reused in another cell.
For example, a valid formula can look as follows:
= 67 + (A3 * sum(B1:C5))