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 1: / Line 1: @@
+[[Category: Excel to Analytica mappings]]
-= AND =
+== AND(logical1'', logical2, ...'') ==
-= FALSE =
-= IF =
+''Analytica equivalent:''
-= NOT =
+:logical1 [[And]] logical2
-= OR =
-= TRUE =
+== 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
+== TRUE() ==
+''Analytica equivalent:''
+:True
+==See Also==
+* [[Excel to Analytica Mappings]]