Posted to microsoft.public.excel.worksheet.functions

svemor

external usenet poster

Posts: 8

{} 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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Identify if Cell is Formula or written number	Claes G	Excel Worksheet Functions	13	December 5th 07 05:01 PM
Count formel. Dont like the new year	svemor	Excel Worksheet Functions	5	January 16th 07 08:15 PM
Date format and weeknum formel	svemor	Excel Discussion (Misc queries)	8	January 16th 07 05:45 PM
Formel for Ã¥ hente tekstbiter til rapporgenerator.	vebjorn	Excel Discussion (Misc queries)	1	October 8th 06 06:04 PM

All times are GMT +1. The time now is 03:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us