Question about {}

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Petro - 14 Aug 2005 21:46 GMT

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?

Reply to this Message

KL - 14 Aug 2005 22:06 GMT

Hi Petro,

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

Regards,
KL

> 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?

Reply to this Message

Chip Pearson - 15 Aug 2005 16:58 GMT

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.

Signature

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

> 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?

Reply to this Message