Question about {}
 

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?

Hi Petro,

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

Regards,
KL


"Petro" wrote in message
...
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?

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


"Petro" wrote in message
...
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?