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

Latest revision as of 20:30, 16 March 2016

Analytica equivalent:

logical1 And logical2

Analytica equivalent:

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.

Analytica equivalent:

Not logical

Analytica equivalent:

logical1 Or logical2

Analytica equivalent:

True

@@ Line 3: / Line 3: @@
 == AND(logical1'', logical2, ...'') ==
-Analytica equivalent:
+''Analytica equivalent:''
- logical1 [[And]] logical2
+:logical1 [[And]] logical2
 == FALSE( ) ==
-Analytica equivalent:
+''Analytica equivalent:''
- False
+:False
 == IF(logical_test, value_if_true'', value_if_false'') ==
-Analytica equivalents:
+''Analytica equivalents:''
- If logical_test Then value_if_true else value_if_false
+:[[IF]] logical_test THEN value_if_true ELSE value_if_false
- IfOnly 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 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: If,  IfOnly and IfAll differ in which dimensions they include in the final result when logical_test is not an array,  or is constant.
+''Note:'' Rarely, you may want to use [[Ifall-Then-Else|Ifall]] or [[Ifonly-Then-Else|IfOnly]] instead of [[If]].
 == NOT(logical) ==
-Analytica equivalent:
+''Analytica equivalent:''
- [[Not]] logical
+:[[Not]] logical
 == OR(logical1'', logical2, ...'') ==
-Analytica equivalent:
+''Analytica equivalent:''
- logical1 [[Or]] logical2
+:logical1 [[Or]] logical2
 == TRUE() ==
-Analytica equivalent:
+''Analytica equivalent:''
- True
+:True
+==See Also==
+* [[Excel to Analytica Mappings]]