Question about {}

[Guest]

Dear Sirs

I saw some functions starting with{ and ending with }
What is used for? Can you give me some hints for using that things?

 

[KL]

Hi Petro,

You may want to have a look at this:
http://office.microsoft.com/en-us/assistance/CH010037001033.aspx

Regards,
KL

 

[Chip Pearson]

The curly braces {} indicate that the formula is an array
formula. You don't type the braces in; instead, you enter the
formula by pressing CTRL+SHIFT+ENTER rather than just ENTER. See
www.cpearson.com/excel/array.htm for more information about array
formulas.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com