On Thu, 29 Sep 2005 15:44:46 +0300, "Arvi Laanemets"
wrote:

Hi

=IF(divisor=0,"",large_formula)

Furthermore, you can define parts of your large_formula as names (named
functions), so that the whole will look like
=IF(Name2=0,"",Name1/Name2)


Arvi,

That's an interesting idea, please tell me more.

How do I name part of the formula. I tried highlighting the relevant
part and going to Insert Name Define as you'd normally do, but the
define bit is greyed out. The Excel help wasn't much help when I
looked.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________