View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
matt2123 matt2123 is offline
external usenet poster
 
Posts: 3
Default formula cant be entered

Shane,

=IF(CAB1!$E$20,CAB1!$A$2,CAB1!F:F)&IF(CAB1!$E$30 ,CAB1!$A$3,CAB1!F:F)&IF(CAB1!$E$40,CAB1!$A$4,CAB1 !F:F).....


I am trying to pull the description of an item from another tab, if column E
has an amount greater then 0. It stops at the 44th entry, but I didnt think I
was over the limits.

Thanks Shane

"ShaneDevenshire" wrote:

Hi Matt,

What do you mean by more than 44? 44 what's? In one cell? Why don't you
show us a little of your formula.

In 2003 and earlier, you are limited to 1,024 characters in a cell formula.
And you are limited to 7 levels deep of nesting. You are also limited to a
maximum of 30 arguments, for example if your formula looked like this
=SUM(IF(...),IF(...)....)

In 2007 these limits are 16,384 bits for formulas, 64 levels of nesting and
255 arguments.

In most cases long IF formulas could be done with other more efficient
techniques.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"matt2123" wrote:

I am tying to enter in some "IF" formulas and it is not allowing me to enter
in more then 44. I checked the specifications and limits and I dont believe
I am over the limit. When I try to enter the 45th one I get this message,
"The specified formula cannot be entered because it contains more values,
references, and/or names than are allowed in the current file format." Cant
anyone give me some info on this, or is there a way to change the "current
file format?"