NOT (logical)

Description:

This function reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.

Syntax: NOT (logical condition)

• Logical Condition : You want to test that can be either TRUE or FALSE.

Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be references that contain logical values.
• If logical is FALSE, NOT returns TRUE; if logical is TRUE, NOT returns FALSE.

Example

= If (NOT(NUM1<NUM2), "Num1", "Num2" )

 

This example returns the statement, "Num1" if the NOT operand returns the value "True", which will be returned if NUM1 is NOT less than NUM2. (i.e.the logical value is false, so NOT returns "True" and the "if true expression" statement is executed).

If the logical condition in the formula statement returns a value "True" then NOT operand returns "False" and forces the function to go to the "if false expression" execution statement, in the IF condition. In this case, the message, "Num2" will be returned if num1 is indeed less than Num2.(Because  num1 < num2 is true, so NOT returns "FALSE")

Num1 and Num2 are member names, and in a real world example they will need to be referenced completely (with dimension and cube names).