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.