Formula Functions

In the price and weight formulas, you can use many functions as in MS Excel.
Some functions are listed below:
IF (condition, [value_if_true], [value_if_false]) : IF statement to test a condition (More information)

This example reduces the price if the width is bigger than 10

Pow(a, b) : equivalent to ab

Mod(a, b) : equivalent to a % b

Max(a, b, …) : returns the biggest value (can take 2 or more parameters)

Min(a, b, …) : returns the lowest value (can take 2 or more parameters)

Round(number, decimals): rounds a number up to the number of the passed decimals places




Was this article helpful to you? Yes 1 No