Using IF in an expression

A test can be performed on data using the IF function. This is based on criteria. The test is defined in the following expression:

If (A1,A2,A3)

A1=Where the test is defined

A2=If the test is true, A2 appears

A3=If the test is false, A3 appears

(Note: If any of the values within A1 are undefined (Zero, Null, or Divide by Zero) a false value will be given and A3 will appear. A2 and A3 must be the same data type)

To use the IF function:

• Open a browse on the schema you wish to use the function on by right clicking on it and selecting Open Browse

• Right click and select Add Column

• Type IF( into the Expressions box, followed by the appropriate data test, and then the outcomes

• The expression should look something like this:

• IF(ACNHC.BASEHHS>6000, ‘High’, ‘Low’)

• Make sure its valid by selecting Validate, then select Add and OK

A screenshot of a computer Description automatically generated