IFS

The IFS function returns a dynamic array whose elements are chosen individually from one of two dynamic arrays based on the contents of a third dynamic array.

COMMAND SYNTAX

IFS (dynamic.array, true.array, false.array)

IFS evaluates each element of the dynamic array. If the element evaluates to true, it returns the corresponding element from true.array to the same element of a new dynamic array. If the element evaluated to false, it returns the corresponding element from false.array. If there is no corresponding element in the correct response array, it returns an empty string for that element. If an element is null, the element evaluates to false.

jBC