{} in formel
 

In my sheet all the formulas has { } around them. E.x:

{=COUNT(IF(Data!$M$2:$N$655360;IF(Data!$O$2:$O$65 536=$A3;IF(YEAR(INT(Data!$L$2:$L$65536))=2006;Data !$M$2:$N$65536))))}

When I enter the formula line the {} disapper, and the formula no longer
returns the same value. Thers no change to the formula or the values in the
refering cells.

Any suggestions?

{} in formel
 

The curly brackets {} indicate an array formula. When you edit the formula
in the formula bar, these disappear. Here's some info on array formulas:
http://www.cpearson.com/excel/array.htm

Dave


--
Brevity is the soul of wit.


"svemor" wrote:

In my sheet all the formulas has { } around them. E.x:

{=COUNT(IF(Data!$M$2:$N$655360;IF(Data!$O$2:$O$65 536=$A3;IF(YEAR(INT(Data!$L$2:$L$65536))=2006;Data !$M$2:$N$65536))))}

When I enter the formula line the {} disapper, and the formula no longer
returns the same value. Thers no change to the formula or the values in the
refering cells.

Any suggestions?

{} in formel
 

The {} indicates an Array formula.

When entering use CTRL + SHIFT + ENTER keys simultaneously.

Excel will place the {} around the formula.


Gord Dibben MS Excel MVP

On Wed, 17 Jan 2007 05:38:00 -0800, svemor
wrote:

In my sheet all the formulas has { } around them. E.x:

{=COUNT(IF(Data!$M$2:$N$655360;IF(Data!$O$2:$O$6 5536=$A3;IF(YEAR(INT(Data!$L$2:$L$65536))=2006;Dat a!$M$2:$N$65536))))}

When I enter the formula line the {} disapper, and the formula no longer
returns the same value. Thers no change to the formula or the values in the
refering cells.

Any suggestions?