Mac Works: Finding the Percentage Change Between Values

PSS ID Number: Q104809 Article last modified on 10-22-1998

1.x 2.x 3.0 4.0

MACINTOSH

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

The information in this article applies to:

- == 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

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

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

# Additional reference words: mac

Version : 1.x 2.x 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.