Formula Values

 

Formulas can contain any or all of the following types of values:

 

ü  Numbers, such as 123, -123, 12.3.

ü  Addresses of single cells, such as A1, D5, Z100.

ü  Addresses of cell ranges such as B12..G29, A1..D5.

ü  Absolute cell references denoted with dollar signs before the fixed coordinate ($A$1, $A1, or A$1), which will not be updated when the referencing cell is moved or copied.

ü  Objective Grid functions, such as @SUM or @RADIANS, with their arguments.

ü  Text surrounded by double quotation marks, such as "The sum is " or "Total".

ü  User-defined cell names or cell range names, such as TOTALS or PROJECT1