Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Formula to show percent increase/decrease

1. I agreed to these rules
Join Date
3rd August 2005
Posts
2

## Formula to show percent increase/decrease

I am trying to add a formula in Excel to show a percent increase or decrease in sales from one month to the next and I can't figure out the formula...Columns are: month and total sales(in dollars). I need to compare month 2 to month 1 and show how much the sales increase or decreased on a percentage basis (Ex: January \$10,000 and February \$15,000...the answer I want is a positive 50%.)

Thanks.

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Formula to show percent increase/decrease

=(FebSales-JanSales)/JanSales

Hope this helps

Alastair

3. ## Re: Formula to show percent increase/decrease

Percentages in Excel

4. I agreed to these rules
Join Date
3rd August 2005
Posts
2

## Re: Formula to show percent increase/decrease

Thanks for the fast help. I think my middle school math teacher is going to hunt me down now for being so dense.

A.

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno