Description:
Null value
Syntax:
null |
Usually the value of an empty cell is null. |
Note:
It can be used directly in a constant cell or expression.
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: