XML Marker Spereadsheet calculator products
Home Overview More details Examples Download Faq
Overview
Entering data
The project window
The base row
Overriding the base row
Color coding
Hide Repeating values
The summary row.
Sorting
Referring to other cells
Range formula
Circular dependency
View source
Using more than one table
Import, export, and delete
Windowing: Optimized Mode
Windowing: Solution layout
Single formula controls a column
A Formula located at the base row (the row labeled with the "base" icon), controls all the cells at the same column. In the following screenshot, the formula =amount/10 in the tax column sets the values of the cells across the column to be 10 percent of the corresponding values from the amount column.

the base row
Screenshot: the formula =amount/10 controls the values of the tax column.

Note that the formula =amount/10 is the only formula at the column - all the other cells are controlled by this formula. 
(back) (Next - Overriding the base row)
Contact info Copyright © 2001-2003 by Symbol Click