Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 -

share|improve this answer

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

Your Answer


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.