What is { } used for in Microsoft Excel 2010?

Question

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)}

VenkatH · Accepted Answer · 2012-10-30 16:36:24Z

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.

SLaks · Answer 2 · 2012-10-30 16:32:53Z

up vote 3 down vote

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

answered Oct 30 '12 at 16:32

SLaks
5,29611241

	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

2 Answers