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.