What are the Charcters "{}" used for

[Guest]

What are the Charcters "{}" used for in a Beginning of a formula and at the
end of a formulain Excel 2003.

 

[Guest]

The left/right brace indicate an array formula. After the formula is entered
press Ctrl+Shift+Enter to place the braces around the formula.

The braces are not typed.

 

[Guest]

I forgot to state this in the previous post.

For an excellent introduction to array formulas check out the following URL:

http://www.cpearson.com/excel/ArrayFormulas.aspx

Chuck Pearson has an excellent website containing a wealth of information
regarding using Excel.

 

[Gord Dibben]

So has Chip Pearson at the same website<g>


Gord Dibben MS Excel MVP

 

[Guest]

Gee, you don't think Chuck, uhh, I meant Chip, will be offended do you?

 

[Gord Dibben]

My take on Chip is that he doesn't offend that easily.

You're not the first to mis-name him and get corrected.

Or maybe you are but forgot<g>

Gord