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
-------
 
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
 
Additional reference words:   mac
======================================================================
Version           : 1.x 2.x 3.0 4.0
Platform          : MACINTOSH
Issue type        : kbinfo
=============================================================================
Copyright Microsoft Corporation 1998.