Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.

How to Use Excel to Make a Corporate Organizational Chart. Creating an organization chart to place in your orientation handout folders or employee manuals helps your staff learn who reports to ...