PICKZEN
Search
K

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)
Argument name
Description
table
Required
Table to evaluate where the first column and row are the variables to evaluate.

Examples

mytable
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 modified 3yr ago