ExcelBanter - Adding {} in the formula line

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding {} in the formula line (https://www.excelbanter.com/excel-discussion-misc-queries/116869-adding-%7B%7D-formula-line.html)

[email protected]

Adding {} in the formula line

What is the command to bracket a formula with { } . I cant remember

Thanks

Dave F

Adding {} in the formula line

It's used with array formulas. Excel automatically adds them to the formula
when an array formula is entered.

CTRL+SHIFT+ENTER is the key combination used to tell XL that you want an
array formula.
--
Brevity is the soul of wit.

" wrote:

What is the command to bracket a formula with { } . I cant remember

Thanks

Gord Dibben

Adding {} in the formula line

CTRL + SHIFT + ENTER

Gord Dibben MS Excel MVP

On Tue, 31 Oct 2006 10:19:02 -0800,
wrote:

What is the command to bracket a formula with { } . I cant remember

Thanks

All times are GMT +1. The time now is 10:46 PM.