CALC

Formula Explanation

Performing basic addition (+), subtraction (-), multiplication (*), and division (/) calculations on a dataset or numbers.

Formula Syntax

In the result column, write:
Column/Value + Column/Value
Column/Value - Column/Value
Column/Value * Column/Value
Column/Value / Column/Value

• All parameters can be represented using column codes, which are the codes at the top of each column in the table, for example: AA1.

Usage Examples

1. The value of BP2 column multiplied by the value of BP3 column plus 3 should be written to BP4 column.

BP4 = BP2 * BP3 + 3

2. The value of (2 * 5) + 3 is 13. Write this result to cell BQ2.

BQ2 = (2*5)+3

✉️ Ask Tablize