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.

Did this answer your question?