Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)}
share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

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

share|improve this answer
add comment

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

share|improve this answer
    
what about the {} brackets? thats what I want to know? –  TankTank Oct 30 '12 at 16:36
    
The {} brackets surround array formulas. That's what he's saying. –  Zac B Oct 30 '12 at 17:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.