Microsoft KB Archive/104809

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.