HASNA - Check input for observations with missing Value

Check whether the input array contains any missing values and returns TRUE or FALSE.


HASNA(X, Option)

is the data set you chose to test. X can refer to a cell range, a formula, or a name that refers to cell ranges, values, or formulas.
is a logical value: to check only for intermediate missing value(s) = TRUE or omitted; to check for any missing value = FALSE.


  1. The time series is homogeneous or equally spaced.
  2. The searches for a missing value (i.e., #N/A or empty cell) in the input time series.

Files Examples

Related Links



Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful