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: Rarely, you may want to use Ifall or IfOnly instead of If.

NOT(logical)

Analytica equivalent:

Not logical

OR(logical1, logical2, ...)

Analytica equivalent:

logical1 Or logical2

TRUE()

Analytica equivalent:

True

See Also

• Excel to Analytica Mappings