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

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

See also

MUL

SUM

DIV

MAX

MIN

AVG

Table of Contents