2

I came across this function in one of my worksheets and wanted to know what the curly braces are used for.

Here is an example.

{=array(sheet1!a1,sheet2!a3,sheet2!a5,sheet2!a6)}

2 Answers 2

0

They are used in Array Formulas.

Excel surrounds the formula with braces ({ }) and places an 
instance of the formula in each cell of the selected range.

Source - http://office.microsoft.com/en-us/excel-help/guidelines-and-examples-of-array-formulas-HA010342564.aspx

3

That's an array formula.
It applies to a range of cells.

2
  • what about the {} brackets? thats what I want to know?
    – TankTank
    Oct 30, 2012 at 16:36
  • The {} brackets surround array formulas. That's what he's saying.
    – Zac B
    Oct 30, 2012 at 17:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .