Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Formulas That Return an Array Result

You can also create array formulas that return an array of different values in a selected range of cells. Formulas that operate on matrices, described in Chapter 9, are examples of formulas that return an array. [Pg.94]

To use a worksheet formula that returns an array result, you must first select a suitable range of cells, with dimensions (R x C) large enough to accommodate the returned array, then type the formula in the formula bar, and finally enter the formula by pressing CONTROL+SHIFT+ENTER. Excel will indicate that the formula is an array formula by enclosing it in braces and will enter the array formula in all the selected cells. [Pg.95]

A few of Excel s worksheet functions are array functions, that is, they return arrays as results. One of these, the LINES statistical function, is described in Chapter 11. [Pg.95]


See other pages where Formulas That Return an Array Result is mentioned: [Pg.94]    [Pg.95]   


SEARCH



Array formula

RETURN

Returnability

© 2024 chempedia.info