Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104809

From BetaArchive Wiki

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.