Another Excel formula required please.

  pj123 17:11 02 May 2004

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 2004

you want (new - old) / old

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

= 95%

  GermfreeUnicycle 17:15 02 May 2004

duh - the last line should read 94%

  QuickHare 17:15 02 May 2004

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 2004

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

Sorry M8 teach me to answer the phone lol

  pj123 18:05 02 May 2004

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.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone