Special functions in Excel
The curly brackets { and } signify that this is an array formula. When
you type it in, or subsequently edit the formula, you should press
CTRL-SHIFT-ENTER (CSE) instead of the normal ENTER. If you do this
correctly, then Excel will insert the curly brackets when the formula
is viewed in the formula bar - you must not type these yourself.
Hope this helps.
Pete
On Feb 28, 4:57 pm, jberlin wrote:
I need to update a worksheet that has a formula that is bounded in curly
brakets "{}". I remember that they are inserted by a special keystroke, a
function key I think, but I can not remember what it is. The Excel help has
no info on it. Anyone know what this is and the keystroke that inserts the
curly brakets?
|