null

Read(222) Label: null value,

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 functions:

true

false