Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Formula to show percent increase/decrease

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    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!

    Comment


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

      This page maybe of help also
      Percentages in Excel

      Comment


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

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X