# 3.5.7.18 IsEmpty

## Description

The IsEmpty() function is similar to MS Excel's ISBLANK function, and is used to determine whether a string or worksheet cell is empty or not. Note that cells containing missing values, denoted by "--", are not considered empty.

int IsEmpty(string str$) ## Parameters str is a string, worksheet cell address, or a vector (e.g. col(A)). ## Return If the cell contains a string, numeric or missing value ("--"), the function returns 0. If the cell or string is empty, the function returns 1. ## Examples string str1=""; isempty(str1$)=; //return 1
col(A)[1]$=str1$;
col(A)[2]$="hello"; isempty(col(A)[2]$)=; // return 0
isempty(A); //returns a dataset contains 1 and 0 respectively (Spreadsheet Cell Notation syntax for Set Values dialog box only)