Difference between revisions of "Excel to Analytica Mappings/Logical Functions"

 
Line 1: Line 1:
 +
= AND(logical1'',logical2,...'') =
  
= AND =
+
Analytica equivalent:
= FALSE =
+
logical1 [[And]] logical2
= IF =
+
 
= NOT =
+
= FALSE( ) =
= OR =
+
 
= TRUE =
+
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

Revision as of 00:29, 12 January 2008

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
Comments


You are not allowed to post comments.