+ Reply to Thread
Results 1 to 4 of 4

Formula for % Increase / Decrease in single cell.

  1. #1
    Registered User
    Join Date
    03-27-2020
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    3

    Formula for % Increase / Decrease in single cell.

    Hi All,

    I have a query regarding the appropriate formula for % increase + decrease.

    For example,

    In cell D2 I have a % increase of 5%, and in E2 I have a % decrease of 2.5%

    In Q2 I have a formula looking at D2 and multiplying the original number in Q2 by D2 to increase the number by the percentage.

    However as the formula I have is =Q2*(1+D2) I cannot drag this across to E2 as E2 would require the "+" to change to a "-".

    However I am looking for a formula that I can change D2 from a negative to a positive and the formula be able to identify if it should increase or decrease my number in Q2.

    Any thoughts?

    Many Thanks,

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,999

    Re: Formula for % Increase / Decrease in single cell.

    How about in E2, instead of 2.5%, you put -2.5%

    =$Q2*(1+D2)

    Drag this across
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-27-2020
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    3

    Re: Formula for % Increase / Decrease in single cell.

    Wow, I can't believe I've missed that. Thank you!!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,999

    Re: Formula for % Increase / Decrease in single cell.

    You are very welcome and thanks for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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