Spread 8.0 Documentation
Chapter 1 Formula Overview
Support Options
Formula Reference > Chapter 1 Formula Overview

Glossary Item Box

Formula Overview


Spread provides the following capability to use when you create formulas.

Formulas can consist of values, operators, and functions. Data can be from other cells, a combination of data in another cell and hard-coded data (for example, A1 + 2), or simply hard-coded data (for example, SUM(4,5)). Formulas can perform mathematical operations, such as addition and multiplication, on values in other cells or they can compare values in other cells. Formulas can refer to cells in the same sheet by their absolute cell location or relative to the cell with the formula in it; they can refer to individual cells or a range of contiguous cells. If the values in the referenced cells change, then the value of the formula cell changes.Formulas can be made up of:

For details on the built-in functions, refer to the Built-In Functions.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.