Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Formula to show percent increase/decrease

  1. #1
    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. #2
    Join Date
    5th May 2005
    Location
    University of Kent!!, UK
    Posts
    988

    Re: Formula to show percent increase/decrease

    =(FebSales-JanSales)/JanSales

    Hope this helps

    Alastair
    Einstein:
    Things should be made as simple as possible, but not any simpler

    Be sure to check out TemplateZone for all your Microsoft Office Needs.
    Get OfficeReady Professional 3.0 here!

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,715

  4. #4
    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


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Increase/Decrease Times By x Hours
    By M40wen in forum EXCEL HELP
    Replies: 3
    Last Post: August 4th, 2008, 17:31
  2. 6.70 X 10% Est. Percent Increase Or Decrease
    By Fargo95 in forum EXCEL HELP
    Replies: 1
    Last Post: April 25th, 2007, 17:16
  3. Format Number to increase/decrease
    By hharidas in forum EXCEL HELP
    Replies: 4
    Last Post: July 31st, 2006, 11:25
  4. Increase/Decrease Values permanently
    By Dave Hawley in forum Excel FAQ
    Replies: 0
    Last Post: October 13th, 2005, 12:18
  5. Increase/Decrease automatically...
    By jacknice in forum EXCEL HELP
    Replies: 4
    Last Post: August 9th, 2005, 08:02

Bookmarks

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