Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula cant be entered
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?" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula cant be entered
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?" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula cant be entered
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?" |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
manual numbers entered in formula | Excel Discussion (Misc queries) | |||
Formula to see if a cell has an entered value | Excel Worksheet Functions | |||
hourglass won't go away after formula was entered | New Users to Excel | |||
Formula does not show as I entered it. | Excel Worksheet Functions | |||
Formula entered not working | Excel Discussion (Misc queries) |