Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

MIN – Select miniumum value

Overview

Returns the minimum of the arguments.

Syntax

MIN (n1, n2, n3)

MIN(10,15,25)

n1, n2, n3 List of numerical values or arguments. Can have as many values/arguments as required.

Examples

MIN(FIELDVAL(‘Price’),10)

Price MIN
5.00 5.00
10.00 10.00
15.00 10.00
17.50 10.00

In the example above MIN(FIELDVAL(‘Price’),10) looks at each value in the Price field and compares it to 10 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 so ‘10.00‘ is returned.

MIN(FIELDVAL(‘Price’),10,17)

Price MIN
5.00 5.00
10.00 10.00
15.00 10.00
17.50 10.00

In the example above MIN(FIELDVAL(‘Price’),10,17) looks at each value in the Price field and compares it to 10 and 17 and returns the minimum value. In row 1, the price is 5.00, which is lower than 10 or 17 so ‘5.00‘ is returned. In row 3, the price is 15.00, which is higher than 10 but lower than 17 so ‘10.00‘ is returned.

See also

MAX

AVG

MOD

MUL

DIV

Table of Contents