Hi Biff

No consolation I know, but it's not your machine.
I have 1 GB RAM and just tested with XL2002 and XL2003 and experienced
the same crash.
I did wonder though, why you were using an array formula as opposed to
=IF(A10,(COUNTIF(A2:A$10,"0")-1)*A1,"")
which produced the expected results for me in both versions.

--
Regards

Roger Govier


"Biff" wrote in message
...
Hi Dave!

This is very frustrating. I would just like to know whether it is in
fact a problem with Excel or maybe my machine configuration isn't up
to the task. (enough ram?) I have 256mb. That isn't a lot by *TODAYS*
standard but that was pretty strong when I got the machine and I've
had this problem since day 1.

I'm getting tired of sending error reports to M$. It'd be nice to get
some feedback from them.

Biff

"Dave Peterson" wrote in message
...
Oops. Never mind that last post. xl2003 crashed too.

(I didn't have anything in A1 and the formula evaluated to "" in my
other test
(doh!!).)



Biff wrote:

I've always had problems with Excel 2002 crashing when I use the
formula
auditing tool, evaluate formula, on really "complex" array formulas.

I'm sad to say Excel has hit a new low and even crashes on a simple
formula
like this:

=IF(A10,(MATCH(TRUE,A2:A$100,0)-1)*A1,"")

It crashes evaluating the array:

A2:A$100

I pretty much have learned what formulas will cause a crash and
don't use
the evaluate formula command on those formulas but this latest one
is a joke
(but I'm not $%^*($%% laughing).

Yes, I know I can highlight expressions and press F9 but it's not
the same
as evaluate formula. Evaluate formula is a great tool when it
doesn't cause
a crash!

Rant over.

Biff

--

Dave Peterson