EVALTABLE

The EVALTABLE function evaluates a table where the first column and row are the variables to evaluate, returning the first matching cell found.

Syntax

EVALTABLE(table)

Examples

EVALTABLE(mytable) Evaluates the table named mytable:

  • If y is true and b is true then it will return 2

  • If z is true and a is true then it will return 7

Last updated