Learn about the first condition Learn about the second condition Input ranges Input ranges Returned values

Formula table grid

Enter the conditions, input ranges, and values to be returned to the formula.

The configuration of the grid depends on whether you select the One dimensional or Two dimensional option.

Click the image below for details.

A formula table grid

Tips:  

  • To insert a new row, select a cell in the grid, and then click [Insert Row] to insert the new row above your current position.
  • To insert a column, select a cell in the grid, and then click [Insert Column].
  • A red background means that the cell requires an entry.