Another Excel formula required please.

  pj123 17:11 02 May 04
Locked

I need a formula to calculate growth rate. eg. If I had 100 employees last year and I now have 150 employees this year the growth rate is 50 percent.
But if I apply the same formula to 1260 last year and now have 2448 it doesn't work. The answer should come out to 94 percent growth rate. This is for an exam coming up shortly. If you think this is cheating please don't answer, but if you do answer at least I will have some idea about working out these formulae. The formula I used only seems to work with 10s, 100s or 1000s but not with anything else. Thank you.

  GermfreeUnicycle 17:15 02 May 04

you want (new - old) / old

i.e (2448 - 1260) / 1260 = 0.94

= 95%

  GermfreeUnicycle 17:15 02 May 04

duh - the last line should read 94%

  QuickHare 17:15 02 May 04

Assuming you know the mathematical symbols (plus, minus, divide and multiplication) in Excel, then look at what you do to calculate it.

It's usually New value divided by Old value, multiplied by 100 (to get to percentage).

That's in words, now try it in numbers in Excel. (Remember, all equations start with "=").

  QuickHare 17:16 02 May 04

Sorry. "New value" should have read "Change in value"

=(new-old)/old * 100 will give you the answer as a pecentage and in the example used should result in 94.28571
HTH

Sorry M8 teach me to answer the phone lol

  pj123 18:05 02 May 04

Thanks a lot guys. Used the one from Whisperer and it worked a treat. You obviously don't think I am cheating.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…