Difference between revisions of "Excel to Analytica Mappings/Logical Functions"
Line 1: | Line 1: | ||
+ | = AND(logical1'',logical2,...'') = | ||
− | + | 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
Enable comment auto-refresher