An array constant is a specially organized list of values that you can use as arguments in your array formulas.

Array constants can consist of numbers, text, or logical values.

You must enclose an array constant in braces—{ and }—and separate its elements with commas and semicolons. Commas indicate values in separate columns, and semicolons indicate values in separate rows.

To enter a formula using an array constant, follow these steps:

1. Select a range of cells the size you need to contain the result. For example, the argument to the INT function contains three groups (separated by semicolons) of three values (separated by commas), which produces a three-row, three-column range.

2. Type the braces around the array argument, to indicate that the enclosed values make up an array constant. (Note that array arguments differ from array formulas, in which you cannot type the braces.)

3. Press Ctrl+Shift+Enter. The resulting array formula contains two sets of curly braces— one set encloses the array constant and the other encloses the entire array formula. When entering array constants, remember that commas between array elements place those elements in separate columns, and semicolons between array elements place those elements in separate rows.