How to Calculate Incremental Growth in Excel

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.

rear view of a businessman using a computer in an office cubicle
You can create forecasts, predictions and estimates with incremental growth expressions.
credit: George Doyle/Stockbyte/Getty Images

Step

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.

Step

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.

Step

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

Step

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.