Please help me with an Excel Formula!!

[Celery]

I have two columns of figures from two consecutive years, and need to work out the percentage changes - has anyone got a simple formula I can use please?

love from a flakey preschool Treasurer.

[WannaBeAYummyMummy]

Where B is the column from the most recent year and A is the column for the year before that.

=(B1-A1)/A1

You then need to format the cell as a percentage.

HTH

WBAYM x

[NotQuiteCockney]

Percentage change for each year? Or what?

You want to do +((-)/)*100

[Celery]

Percentage change between 2005/06 and 2006/7. Column A is most recent year, colum B the year before.

Thank you everyone.

[gustav]

Hi looks like you are sorted on this conversation. I only came on line to look at the Mel Smith discussion of his appearance on Mastermind but there is a free download of basic Excel calcualtions on
www.mousetraining.co.uk/ms-office-training-manuals.html