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

=IF(CAB1!$E$2,CAB1!$A$2,CAB1!F:F)&IF(CAB1!$E$3,CAB 1!$A$3,CAB1!F:F) ---- That
is basically what I am foing 44 times. It is 2007


"Jim Thomlinson" wrote:

Are you attempting to have one formula with more than 44 if statements in
it??? Also what version of XL?
--
HTH...

Jim Thomlinson


"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?"