Rant!

Giganews Newsgroups
Subject: Rant!
Posted by:  Biff (biffinpi…@comcast.net)
Date: Mon, 22 May 2006

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(A1>0,(MATCH(TRUE,A2:A$10>0,0)-1)*A1,"")

It crashes evaluating the array:

A2:A$10>0

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

Replies