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.
SUB – Subtract one value from another
Overview
This Custom Field will subtract the values in the second and subsequent parameters from a first parameter.
Syntax
SUB(Parameter1,Parameter2, Parameter3…)
SUB(100,15,25)
| Element | Description |
|---|---|
| Parameter1 | A given number. |
| Parameter2, Parameter3… | The number(s) to subtract from the given number. |
Examples
SUB(100,15,30) returns ‘55‘.
SUB(FIELDVAL(‘Price’), 18, 4, 3)
| Price | SUB(FIELDVAL(‘Price’), 18, 4, 3) |
|---|---|
| 30.00 | 5.00 |
| 45.00 | 20.00 |
| 58.75 | 33.75 |