Formula Example

Consider cells B2 and C2 in the following worksheet, Sheet1:

Here, the formulas themselves are displayed in the cells.

Here, the results of the formulas are displayed in the cells.

The formula is expressed in Sheet1's XML, as shown in the following subclause.