Before creating the calculation, decide where you want it to go. It is easier to insert a new column between two existing columns before you create the calculation than it is to cut/paste the column after it has been created.
Ensure the anchors are set properly. Is the proper cell reference F2, $F$2, F$2, or $F2?
Copy/paste to all other rows
Give the column a name
If you added the calculation to the last column and auto-filter is on, then refresh auto-filter so the new column is included in the auto-filter.
From Tools, click Compute.
Type the name of the new column in the For field.
Use one of the following methods to add the function to the formula:
See the Supported functions section of this article for information on the available functions.
Use one of the following methods to add the column between the parentheses in the formula:
Example: The column's title is Hire Date, type @Hire_Date@.