FINDIFS Functions

This article explains how to use FINDIFS functionss

Sample Usage

FS
FINDIFS(DA_C, DA_A, 1, DA_B, 2)
FS
FINDIFS(DA_C, DA_A, QA, DA_B, QB)

Syntax

FS
FINDIFS(find_column_reference, criteria_column_reference1, criterion1, [criteria_column_reference2, criterion2, …])
  • find_column_reference
    • the column reference where the first matching item is returned
  • criteria_column_reference1
    • the column reference of cells to be evaluated by criterion1.
  • cirterion1
    • the condition to be met by cells in criteria_column_reference1.
  • criteria_column_reference2, criterion2, … (optional) - additional column references and criteria to test.
ConvertCalculator Icon

The and