Where can I find { } that I need to use for entering a constant?
 

I need to use { } sign for entering constant value in a formular. Can anyone
please help?

Great thanks!

Where can I find { } that I need to use for entering a constant?
 

an arry formula? instead of just hitting enter when you complete a formula
you need to hit ctrl and shift and enter
--
paul
remove nospam for email addy!



"Jason" wrote:

I need to use { } sign for entering constant value in a formular. Can anyone
please help?

Great thanks!

Where can I find { } that I need to use for entering a constant?
 

I don't understand your question. If you need to enter an array
within a formula, just type the characters normally. E.g.,

=SUM(LARGE(A1:A5,{1,2,3}))

If you are using an array formula, you don't type in the {}
characters. Instead, you press Ctrl+Shift+Enter rather than just
Enter, and Excel will automatically insert the {} character
around the formula. You don't type in the {} characters in an
array formula.


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



"Jason" wrote in message
...
I need to use { } sign for entering constant value in a
formular. Can anyone
please help?

Great thanks!

Where can I find { } that I need to use for entering a constant?
 

ON my keyboard they are just to the right of the letter P with [ and
] lower case and { and } uppercase. ed

Where can I find { } that I need to use for entering a constant?
 

ON my keyboard they are just to the right of the letter P with [ and
] lower case and { and } uppercase. ed