what do { } mean/do?

[rob41]

Hi, I am trying to edit a formula in a cell -:

{=AVERAGE(IF(Figures!IV$2:IV$698=L163,Figures!M$2:M$698))}

As soon as I enter the cell to change, the { } from around the formula
disappear.
If I enter them manually the formula stops working.

Can someone tell me what they are and how I can edit the formula without
losing this (what seems like) "formula protection" of some kind?

 

[Tim Zych]

They tell Excel to calculate the formula as an array formula but cannot be
entered manually. In formula edit mode, press Ctrl + Shift + Enter. That
will make the formula an array formula again.

 

[Fred Smith]

{...} signify you have an array formula. It must be committed with
Ctrl-Shift-Enter, rather than just Enter.

So, modify the formula as usual, but hit Ctrl-Shift-Enter when you're done.

Regards,
Fred.

 

[rob41]

Brilliant and very fast - you guys are awesome! thanks