Bracket {..} in formulas
Hi,
that is an array formula if you edit and press enter the { dissapear, when
editing the formula what you have to do is to press CTRL+SHIFT+Enter and your
{} will be added to your formula
"milet" wrote:
I encountered a formula in a spreadsheet which starts and ends with {=...}
these brackets. The formula refers sum (although in reality it is sumproduct)
The brackets are visible in the formula bar, but not in the cell when I
double click it. When I click in the formula bar the brackets disappear and
the formula stops working. It is not possible to copy this back from the
original workbook. When typing it back the formula become ordinary text.
--
milet
|