Checks whether the input array contains any missing values and returns TRUE or FALSE.
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.
- The time series is homogeneous or equally spaced.
- The searches for a missing value (i.e. #N/A or empty cell) in the input time series.