Introduction

A SpreadsheetML formula is an equation that performs a calculation that typically involves the values of one or more cells in one or more worksheets.

A formula is an expression that can contain the following: constants, operators, cell references, calls to functions, and names.

[Example: Consider the formula PI()*(A2^2). In this case,

• PI() results in a call to the function PI, which returns the value of π.

• The cell reference A2 returns the value in that cell.

• 2 is a numeric constant.

• The caret (^) operator raises its left operand to the power of its right operand.

• The parentheses, ( and ), are used for grouping.

• The asterisk (*) operator performs multiplication of its two operands.

end example]