Re: formula to long

From: "Nick Hodge" <nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx>
Date: Thu, 26 May 2005 08:18:44 +0100

Dickey

You know the simple answer to this ;-)

You will need to look at the functions you are using to see if it can be
shortened, for example multiple IFs may be shortened by using a table and
VLOOKUPs for example. Without further info it's difficult to diagnose

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx

"Dickey" <Dickey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E98B6AA-4BBA-4BA2-8F43-6EBD6F9597D8@xxxxxxxxxxxxxxxx
> is there a way to get around the error "formula to long"

.

References:
- formula to long
  - From: Dickey

Prev by Date: Re: Disable save function
Next by Date: Re: Minimise Excel after several minutes
Previous by thread: formula to long
Next by thread: colums in xcel
Index(es):
- Date
- Thread