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: