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

DIV – Divide one number by another

Overview

This Custom Field divides one number by another.

Syntax

DIV(Number1, Number2)

Element Description
Number1 The number to be divided.
Number2 The number to divide by.

Examples

DIV(FIELDSTR(Price), 0.8)

The above Custom Field will select a value in a price list (below left) and divide it by 0.8, returning the calculated value (below right).

Price DIV(FIELDSTR(Price), 0.8)
12.00 15.00
15.00 18.75
17.50 21.88
22.75 28.44
100.00 125.00

DIV(FIELDSTR(Quantity), 4)

The above Custom Field will select a value in a price list (below left) and divide it by 0.8, returning the calculated value (below right).

Quantity DIV(FIELDSTR(Price), 4)
25 6.25
100 25.00
80 20.00
1000 200.00
256 64.00

See also

MUL

SUM

SUB

MAX

MIN

AVG

Table of Contents