Results from the operation will be displayed in a new column with a custom name.
Sum
Select two or more columns using the dropdown.
Options:
- Add cell value. Enter the row and column of a specific value, for example
A3. The same value will be used for each operation, for every row. - Add constant value. Enter a constant number to add it to each operation, for every row.
Subtract
Select two columns to subtract one to the other.
Multiply
Select two or more columns using the same dropdown.
- Multiply by cell value: Enter the row and column of a specific value, for example
A3. The same value will be used for each operation, for every row. - Multiply by constant value: Enter a specific number to multiply by. The same value will be used for each operation, for every row.
Divide
Select two columns to divide one by the other.