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

J

Jason

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

Great thanks!
 
P

paul

an arry formula? instead of just hitting enter when you complete a formula
you need to hit ctrl and shift and enter
 
C

Chip Pearson

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
 
E

edcosoft

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

edcosoft

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