Xindex1

The xindex1(x, dataset) function returns the index number of the first cell in the X dataset associated with dataset, where the cell value is greater than or equal to x.

Requirements:

  • dataset must be a designated Y dataset.
  • The Y dataset name must correspond to an actual Y dataset.
  • The X dataset must be sorted in ascending order.

Examples

ix=xindex1(4.5,Book1_B);

See Also