# Arrays in a Formula

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



Formulas may include functions that operate on arrays. Spread supports array constants in formulas. Use curly brackets { } to enclose the array elements. Use a comma to separate elements within a row. Use a semicolon to separate rows within the array. Individual elements can be number values, text values, logical values, or error values. Some examples of arrays are:

* CORREL({5,10,15,20,25},{4,8,16,32,64})
* CORREL({73000,45000,40360},{42,70,40})
* ROWS({1,2,3;4,5,6})