HASNA - Check input for observations with missing Value

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

Syntax

HASNA(X, Option)

X
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.
Option
is a logical value: to check only for intermediate missing value(s) = TRUE or omitted; to check for any missing value = FALSE.

Remarks

  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

References

Comments

Article is closed for comments.

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