Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

IFS

Description

The 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. It takes the general form:

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 evaluates 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, that element evaluates to false.


Go back to jBASE BASIC.

Was this article helpful?