How do I make an “IF” statement in an expression? I would like to first identify an element with >100 ppm and then perform a calculation on only those samples.

A. If you wanted to add 1 to all sample values over 100 ppm (and leave all sample values < 100 as 0) for example then the syntax would be along the lines of:

Input Column = Cu_ppm = A

Expression: If (A>100,A+1,0)

The If statement has three components:

• The selection expression: eg. A>100

• The result if not 0: eg. A+1

• The if 0: eg. 0

See Calculation Syntax for more information on creating expressions.

代 写