Share via

Excel 2016, How to calculate Growth percentage for minus and plus numbers? I tried a lot but still problem with the minus numbers.

Anonymous
2018-04-23T19:59:38+00:00

Hi all

I am using Excel 2016 and I need to calculate the Growth percentage between 2 numbers, maybe one of them in minus or plus, but always there are mistakes, for example:

I used for example: 

=D35/C35 : (First Month C which is -674,868.00 and second Month D is 94,165.00 = -14% How????

=((D35-C35)/C35)*100% -674,868.00 and 94,165.00 = -114%

Can any one help me please?

Regards

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. DaveM121 869.7K Reputation points Independent Advisor
    2018-04-23T20:11:19+00:00

    Hi Tarik, growth rate percentage is generally calculated with this formula

    =(Last number/first number)^(1/number of intervals)-1

    Which is:

    =(D35/C35)^(1/1)-1

    to force a positive number, wrap that formula in an ABS function

    =ABS((D35/C35)^(1/1)-1)

    3 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2018-04-23T23:28:22+00:00

    Hi,

    Try this

    =IF(OR(AND(C35<0,D35<0),AND(C35<0,D35>0)),(D35-C35)/ABS(C35),D35/C35-1)

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-04-23T20:23:40+00:00

    Thank you very much, it's works 100%

    Regards

    0 comments
  3. Anonymous
    2018-04-23T20:22:45+00:00

    Thanks ChrisMenard_7 for your help, it's the same problem and DaveM121 has a good fix.

    Regards

    0 comments
  4. Anonymous
    2018-04-23T20:08:47+00:00

    Hello Tarik. See if this screenshot helps. I took your data and I added two other examples. Based on your information, I come up with -114%.

    0 comments