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
1 |
IF ( [width] > 10, [price] * 0.8, [price] ) |
Pow(a, b) : equivalent to ab
1 |
Pow ( [size], 2) |
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
1 2 3 |
Round ( 2.5, 0 ) = 3 Round ( 2.55, 1 ) = 2.6 Round ( 2.554, 2) = 2.55 |