IFS()

IFS()

Top  Previous  Next

 

The IFS() function returns a dynamic array constructed from elements chosen from two other dynamic arrays depending on the content of a third dynamic array.

 

 

Format

 

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

 

where

 

control.arrayis a dynamic array of True / False values.

 

true.arrayholds values to be returned where the corresponding element of control.array is True.

 

false.arrayholds values to be returned where the corresponding element of control.array is False.

 

 

The IFS() function examines successive elements of control.array and constructs a result array where elements are selected from the corresponding elements of either true.array or false.array depending on the control.array value.

 

 

Example

 

A contains  1VM0VM0VM1VM1VM1VM0

B contains  11VM22VM3VM4VM91VM36VM7

C contains  14VM61VM2VM0VM35VM18VM3

 

D = IFS(A, B, C)

 

D now contains  11VM61VM2VM4VM91VM36VM3

 

 

See also:

ANDS(), EQS(), GES(), GTS(), LES(), LTS(), NES(), NOTS(), ORS(), REUSE()