Description:
Null value
Syntax:
|
null |
The value of an empty cell is usually null. |
Note:
By default, null is infinitesimal. It can be used directly in a constant cell or expression.
When “Null Control” option in IDE is checked or when “nullPropagate” node in configuration file raqsoftConfig.xml under the IDE is true, all arithmetic, logical, comparison and string computations containing null return null. In those cases, null isn’t equivalent to false; and aggregate operations (such as sum, count, etc.) will automatically ignore the null value. The rule also applies to concat() function.
Example:
|
|
A |
B |
|
|
1 |
=null |
|
Assign a null value to A1. |
|
2 |
=A1==null |
|
Judge if A1 is null. |
|
3 |
if A2==true |
>a=4 |
If it is null, assign 4 to a. |
|
4 |
else |
>a=3 |
Otherwise, assign 3 to a. |
Related function: