# Microsoft KB Archive/104809

Mac Works: Finding the Percentage Change Between Values

1.x 2.x 3.0 4.0

MACINTOSH

## ======================================================================

• == Microsoft Works for the Macintosh, versions 1.x, 2.x, 3.0 and 4.0 ==

# SUMMARY

In Microsoft Works, there is no built-in function to calculate the percentage of change from one value to another. However, the percentage of change can be calculated using a simple formula. The following formula calculated the percent of change

=(New_Value-Original_Value)/Original_Value

where Original_Value represents what the percent change is based on and New_Value represents the value that has changed. You would then need to format the cell containing the formula with a percentage format.

## Example

1. Enter the following in a new spreadsheet:

A1:Sales for 1990 B1:Sales for 1991 A2: \$100,000 B2: \$175,000

A4:Percent Change B4: =(B2-A2)/A2

2. With cell B4 selected, choose Number from the Format menu and choose one of the Percent format codes.

You will see that the sales increased 75% over last year. This is the percent of change.

KBCategory: kbother KBSubcategory: macworkskb