CONFIGURE COLUMNS
Calculated columns
Build a calculation with your own columns, check a few results, and add it to your table. No formula knowledge is needed to get started.
Create a calculated column
Add any source columns you need before building the calculation.
- 1
Open Calculated columns
Edit the macro. In Columns, choose Add column, then Calculated columns.
- 2
Build and preview
Choose With help or Advanced. Check the first-row result and the Draft column in the table preview.
- 3
Add and save
Enter a Column header and check the detected data type. Select Add calculation, then save the macro.
Choose how to build it
Both modes produce the same kind of calculated column. Formula knowledge is optional.
With help
Select a column, number, function, or condition. Combine values with +, −, ×, ÷, or text joining. The editor offers compatible choices.
Advanced
Write the expression directly. The editor supplies the first = and suggests columns and functions. Selecting a column keeps its reference attached when the heading changes.
Example: calculate a line total
Quantity 2 multiplied by Unit Price 2,499 gives 4,998.
- Source values
- Quantity = 2 · Unit Price = 2,499
- Calculation
- Quantity × Unit Price
- Result
- 4,998
Preview and validation
Check the draft before making it part of the saved table.
Draft column
A valid calculation appears with a gray Draft label and dashed borders. Add calculation keeps it; Cancel removes it.
Column references
Choose columns from suggestions, especially when headings repeat. Removing a referenced column produces an error.
Values and functions
An empty first row may show no preview result. Arithmetic needs numbers; NUM() converts formatted number text. SUM() uses all data rows.