We Use Cookies

We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with this.

See our cookie policy.

Automation Action: Math

Perform mathematical calculations and save the result to a variable.

Built-In Action

Executes mathematical formulas and returns the result to a variable.

Enter the Formula text. The formula can contain %variable% replacements.

Select the variable to receive the result from the Assign To list.

Formulas can be as simple as %Price% * %Amount% which would return the value held in %Price% multiplied by the value held in %Amount%.

Click the Validate button to check the formula.

The following mathematical operations are supported:

  • Addition: +
  • Subtraction: -
  • Multiplication: *
  • Division: /
  • Modulo: %
  • Exponentiation: ^
  • Negation: !

Standard Functions:

Function Arguments Description
sum sum(A1, ..., An) Total
roundup roundup(A1,Digits) Rounds up decimal to specified digits
sin sin(A1) Sine
cos cos(A1) Cosine
asin asin(A1) Arcsine
acos acos(A1) Arccosine
tan tan(A1) Tangent
cot cot(A1) Cotangent
atan atan(A1) Arctangent
acot acot(A1) Arccotangent
loge loge(A1) Natural Logarithm
log10 log10(A1) Common Logarithm
logn logn(A1, A2) Logarithm
sqrt sqrt(A1) Square Root
if if(A1, A2, A3) If Function
max max(A1, ..., An) Maximum
min min(A1, ..., An) Minimum
avg avg(A1, ..., An) Average
median median(A1, ..., An) Median
round round(A1) Round
random random() Random
For more complex calculations you can use the Create Spreadsheet action. The Create Spreadsheet action allows you to assign %variables% to cells and then read-back cell values to %variables% after all formulas have been re-calculated.