Excel to Analytica Mappings/Logical Functions

AND(logical1, logical2, ...)

Analytica equivalent:

logical1 And logical2

FALSE( )

Analytica equivalent:

False

IF(logical_test, value_if_true, value_if_false)

Analytica equivalents:

If logical_test Then value_if_true else value_if_false
IfOnly logical_test Then value_if_true else value_if_false
IfAll logical_test Then value_if_true else value_if_false

Note: If, IfOnly and IfAll differ in which dimensions they include in the final result when logical_test is not an array, or is constant.

NOT(logical)

Analytica equivalent:

Not logical

OR(logical1, logical2, ...)

Analytica equivalent:

logical1 Or logical2

TRUE()

Analytica equivalent:

True