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.
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 |