+ Reply to Thread
Results 1 to 6 of 6

Formula to find percentage for a value (Increase/Decrease)

  1. #1
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Formula to find percentage for a value (Increase/Decrease)

    Hello,

    I am looking for help to write a formula for % increase/Decrease. Below is the details.

    I have 2 values i.e. Old and New Let assume that Old value = 6056 and New value is 9267. i know that the increase value is 3202 but i need the percentage also. If the old value is smaller then the new value it should appear (-) minus sign in percentage.

    Can any one help me please.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Formula to find percentage for a value (Increase/Decrease)

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 02-03-2013 at 11:02 AM. Reason: Adjusted tags
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Re: Formula to find percentage for a value (Increase/Decrease)

    Thanks for your response but tel me a2 is old value or new value

  4. #4
    Forum Contributor
    Join Date
    10-22-2012
    Location
    hyd
    MS-Off Ver
    2010
    Posts
    159

    Re: Formula to find percentage for a value (Increase/Decrease)

    Hi,

    Just confirm me:
    You want to know what is the percentage of increase and decrease from the old value to new value..right

    Regards,
    PRB

  5. #5
    Valued Forum Contributor
    Join Date
    01-11-2012
    Location
    Riyadh, K.S.A.
    MS-Off Ver
    Windows 11 with Excel 2013 & 2016
    Posts
    906

    Re: Formula to find percentage for a value (Increase/Decrease)

    yes true. I want to know the % whether it is increased or decreased.

  6. #6
    Forum Contributor
    Join Date
    10-22-2012
    Location
    hyd
    MS-Off Ver
    2010
    Posts
    159

    Re: Formula to find percentage for a value (Increase/Decrease)

    You have to use
    New value - old value /old value * 100

    Regards,
    PRB

+ 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