Difference between revisions of "Excel to Analytica Mappings/Logical Functions"
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | [[Category: Excel to Analytica mappings]] | |
− | + | == 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 | ||
+ | :[[If-Then-Else#Ifonly-Then-Else|IfOnly]] logical_test Then value_if_true else value_if_false | ||
+ | :[[Ifall-Then-Else|IfAll]] logical_test Then value_if_true else value_if_false | ||
− | + | ''Note:'' Rarely, you may want to use [[Ifall-Then-Else|Ifall]] or [[Ifonly-Then-Else|IfOnly]] instead of [[If]]. | |
− | + | == NOT(logical) == | |
− | |||
− | + | ''Analytica equivalent:'' | |
+ | :[[Not]] logical | ||
− | + | == OR(logical1'', logical2, ...'') == | |
− | |||
− | + | ''Analytica equivalent:'' | |
+ | :logical1 [[Or]] logical2 | ||
− | Analytica equivalent: | + | == TRUE() == |
− | + | ||
+ | ''Analytica equivalent:'' | ||
+ | :True | ||
+ | |||
+ | ==See Also== | ||
+ | * [[Excel to Analytica Mappings]] |
Latest revision as of 20:30, 16 March 2016
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
Comments
Enable comment auto-refresher