MS Works Spreadsheets Formulas

Updating MS Works Spreadsheets Formulas

MS Works Spreadsheet Formulas

© Ted French

Updating MS Works Spreadsheets Formulas

When you use cell references in an MS Works spreadsheet formula, the formula will automatically update whenever the relevant data in the spreadsheet changes.

For example, if you realize that the data in cell A1 should have been an 8 instead of a 3, you only need to change the contents of cell A1.

MS Works updates the answer in cell C1. The formula, itself, doesn't need to change because it was written using cell references.

Changing the data

1. Click on the cell A1
2. Type an 8
3. Press the ENTER key on the keyboard

The answer in cell C1 where the formula is, immediately changes from 5 to 10, but the formula itself is unchanged.

• Formulas Overview
• Writing the Formula
• Cell References in Formulas
• Updating MS Works Spreadsheets Formulas
• Mathematical Operators in Formulas
• MS Works Spreadsheets Formula Tutorial: Step 1of 3 - Entering the Data
• Step 2 of 3: Type in the Equal (=) Sign
• Step 3: Adding Cell References Using Pointing