	Related Topics:
	Spreadsheet Data Source Functions Data Entry Tips for Functions

EF

Description: Returns a value from the Effectiveness Factor window, based on the specified row and column location. Use numbers to identify both the row and column (e.g., for cell A2 in the Effectiveness Factor window, enter 2 for the row and 1 for the column).

Syntax: EF (Data_Src, Row, Column)

Data_Src is the source data sheet from which the value is calculated.

Row is the row number in the data sheet.
Column is the column number in the data sheet.

Remarks:

The Data_Src can be one of the following values:

If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in the Defined Names window (e.g., datasource).

The Row and Column values must be greater than 0.

Example:

EF(“Folio1!Data 1”,3,2) = 0.67

Note that this value will vary depending on the source data set.