Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
How do I add more functions when I get the error "Too many functions"? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
I've never seen this error before! There's a memory limit on variables, and also a limit of 50 dll calls. Maybe this is a similar thing. why do you need so many functions? "SwEdIsH_OfFiCe_UsEr" wrote in message ... How do I add more functions when I get the error "Too many functions"? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
I was a bit unclear, but "Too many functions" was not the exact message I get. I had two fields identical except that one had one extra "if" function and when I tried to paste another function into them it worked on the shorter one, but the other one said (literarily, this time): " The formula you typed contains an error. * For information about fixing common formula problems, click Help. * To get assistance in entering a function, click OK, then click Function on the Insert menu. * If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark ('). " It seems to me that there are too many functions, because if I remove a function, I can press enter. How do I solve this problem? "Patrick Molloy" wrote: I've never seen this error before! There's a memory limit on variables, and also a limit of 50 dll calls. Maybe this is a similar thing. why do you need so many functions? "SwEdIsH_OfFiCe_UsEr" wrote in message ... How do I add more functions when I get the error "Too many functions"? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
Post the formula that gives you this message "SwEdIsH_OfFiCe_UsEr" wrote: I was a bit unclear, but "Too many functions" was not the exact message I get. I had two fields identical except that one had one extra "if" function and when I tried to paste another function into them it worked on the shorter one, but the other one said (literarily, this time): " The formula you typed contains an error. * For information about fixing common formula problems, click Help. * To get assistance in entering a function, click OK, then click Function on the Insert menu. * If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark ('). " It seems to me that there are too many functions, because if I remove a function, I can press enter. How do I solve this problem? "Patrick Molloy" wrote: I've never seen this error before! There's a memory limit on variables, and also a limit of 50 dll calls. Maybe this is a similar thing. why do you need so many functions? "SwEdIsH_OfFiCe_UsEr" wrote in message ... How do I add more functions when I get the error "Too many functions"? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
there used to be an issue with nested IF statements ... 7 was the limit i find it best to create your own User Defined Function (UDF) and to use the SELECT /END SELECT statements show us the formula that you're trying to use, and we'll see if there's a nice way to implement a UDF "Mike H" wrote in message ... Post the formula that gives you this message "SwEdIsH_OfFiCe_UsEr" wrote: I was a bit unclear, but "Too many functions" was not the exact message I get. I had two fields identical except that one had one extra "if" function and when I tried to paste another function into them it worked on the shorter one, but the other one said (literarily, this time): " The formula you typed contains an error. * For information about fixing common formula problems, click Help. * To get assistance in entering a function, click OK, then click Function on the Insert menu. * If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark ('). " It seems to me that there are too many functions, because if I remove a function, I can press enter. How do I solve this problem? "Patrick Molloy" wrote: I've never seen this error before! There's a memory limit on variables, and also a limit of 50 dll calls. Maybe this is a similar thing. why do you need so many functions? "SwEdIsH_OfFiCe_UsEr" wrote in message ... How do I add more functions when I get the error "Too many functions"? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
More functions
IF(L21;IF(AND(K20;L20;OR(K22;K2(L2-1)));LOOKUP(MIN(3;K2;L2)-2;I30:I33;IF(AND(K2=1;L2=1);O30:O31;IF(AND(K2=2;L2 =1);N30:N31;IF(AND(K2=2;L2=2);L30:L32;IF(AND(K22; L2=1);M30:M31;IF(AND(K22;L2=2);K30:K32;J30:J33))) )));0);0) "Patrick Molloy" wrote: there used to be an issue with nested IF statements ... 7 was the limit i find it best to create your own User Defined Function (UDF) and to use the SELECT /END SELECT statements show us the formula that you're trying to use, and we'll see if there's a nice way to implement a UDF "Mike H" wrote in message ... Post the formula that gives you this message "SwEdIsH_OfFiCe_UsEr" wrote: I was a bit unclear, but "Too many functions" was not the exact message I get. I had two fields identical except that one had one extra "if" function and when I tried to paste another function into them it worked on the shorter one, but the other one said (literarily, this time): " The formula you typed contains an error. * For information about fixing common formula problems, click Help. * To get assistance in entering a function, click OK, then click Function on the Insert menu. * If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark ('). " It seems to me that there are too many functions, because if I remove a function, I can press enter. How do I solve this problem? "Patrick Molloy" wrote: I've never seen this error before! There's a memory limit on variables, and also a limit of 50 dll calls. Maybe this is a similar thing. why do you need so many functions? "SwEdIsH_OfFiCe_UsEr" wrote in message ... How do I add more functions when I get the error "Too many functions"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |