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

 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
= AND(logical1'',logical2,...'') =
+
[[Category: Excel to Analytica mappings]]
  
Analytica equivalent:
+
== AND(logical1'', logical2, ...'') ==
logical1 [[And]] logical2
 
  
= FALSE( ) =
+
''Analytica equivalent:''
 +
:logical1 [[And]] logical2
  
Analytica equivalent:
+
== FALSE( ) ==
False
 
  
= IF(logical_test,value_if_true'',value_if_false'') =
+
''Analytica equivalent:''
 +
:False
  
Analytica equivalents:
+
== IF(logical_test, value_if_true'', 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
 
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.
+
''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
  
= NOT(logical) =
+
''Note:'' Rarely, you may want to use [[Ifall-Then-Else|Ifall]] or [[Ifonly-Then-Else|IfOnly]] instead of [[If]].
  
Analytica equivalent:
+
== NOT(logical) ==
[[Not]] logical
 
  
= OR(logical1'',logical2,...'') =
+
''Analytica equivalent:''
 +
:[[Not]] logical
  
Analytica equivalent:
+
== OR(logical1'', logical2, ...'') ==
logical1 [[Or]] logical2
 
  
= TRUE() =
+
''Analytica equivalent:''
 +
:logical1 [[Or]] logical2
  
Analytica equivalent:
+
== TRUE() ==
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


You are not allowed to post comments.