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.
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.
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.
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."
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.
Tips & Warnings
- If your worksheet contains a large amount of data and you are calculating values based on a single column, copy and paste that column into a new tab of the same workbook. Placing your column into its own tab minimizing confusion.
- Add labels to your columns by typing brief descriptions into the first blank row of the spreadsheet. Create a new column label row by right-clicking the first row header and selecting "Insert."