+ Reply to Thread
Results 1 to 2 of 2

Percentage formula

  1. #1
    Registered User
    Join Date
    02-09-2005
    Posts
    1

    Percentage formula

    Can someone help me with a percentage formula?
    Example:
    If I post a column of stock prices in column A on Jan1st.
    Then make a column B of the same stock prices on Feb 1st.
    I need a formula that will tell me the percent of price increase (or decrease)
    of the new prices in column B
    Thanks,
    Rod

  2. #2
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by rod848
    Can someone help me with a percentage formula?
    Example:
    If I post a column of stock prices in column A on Jan1st.
    Then make a column B of the same stock prices on Feb 1st.
    I need a formula that will tell me the percent of price increase (or decrease)
    of the new prices in column B
    Thanks,
    Rod
    =(new price in column B - old price in column A)/old price in Column A

    is the formula that you need.
    BenjieLop
    Houston, TX

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1