How to Calculate Incremental Growth in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
You can create forecasts, predictions and estimates with incremental growth expressions.
Image Credit: George Doyle/Stockbyte/Getty Images

Calculate incremental growth in your Microsoft Excel workbook with expressions. Expressions are formulas that calculate information based on numbers, cell references and operators. Incremental growth is an increase in value based on a number. For example, incremental growth describes a company that increases its employee count by five employees each year. You can calculate the incremental growth of your data set by creating an expression and copying and pasting the formula into all pertinent records.

Advertisement

Step 1

Open the Microsoft Excel worksheet that contains your data. If you want to calculate incremental growth based on existing information, open your worksheet to the pertinent tab. If you want to calculate incremental growth based on new values, create a new worksheet or tab.

Video of the Day

Step 2

Organize your worksheet so that you have your data set in continuous columns. Place the calculated cell to the right of your data set. Begin your calculated cell with the "=" symbol without the quotation marks.

Advertisement

Step 3

Type your expression into the calculated cell with cell references, operators and the incremental value. For example, to calculate the growth of your sales quantity "$15,442" stored in column A by 15 percent, calculate the increase value and then add it to the original number. In column B type "=(A2*0.15)" without the quotation marks to return $2316.30 and in column C type "=(A2+B2)" to calculate "$17758.30."

Advertisement

Advertisement

Step 4

Calculate the same incremental growth for all of your records. Copy the expressions into additional rows by highlighting the calculated cells, then clicking, holding and dragging the bottom right-hand corner. Save your Excel spreadsheet when complete.

Video of the Day

Advertisement

Advertisement

references

Report an Issue

screenshot of the current page

Screenshot loading...