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