learn excel - percentage growth formula

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » learn excel - Percentage growth formula

# learn excel - Percentage growth formula

Resolved · Low Priority · Version Standard

Caroline has attended:
Excel Intermediate course

### Percentage growth formula

Do you know what formula you type to work out the percentage growth of a series of numbers over a time period? i.e. how much each consecutive figure has increased/decreased by?

### RE: percentage growth formula

Hi Caroline,

Thanks for your question.

The formula will involve a subtraction and a division. For example, if:

Month Value
Jan 12
Feb 6

then the formula is =(Feb value - Jan value)/Feb value

You will need to format the cell containing the formula to display as a percentage as well.

Amanda

Training courses

Training information:

See also:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips

Server loaded in 0.07 secs.