S
SwEdIsH_OfFiCe_UsEr
How do I add more functions when I get the error "Too many functions"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Patrick Molloy
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?
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?
S
SwEdIsH_OfFiCe_UsEr
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?
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?
M
Mike H
Post the formula that gives you this message
SwEdIsH_OfFiCe_UsEr said: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?
P
Patrick Molloy
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
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
S
SwEdIsH_OfFiCe_UsEr
IF(L2>1;IF(AND(K2>0;L2>0;OR(K2>2;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(K2>2;L2=1);M30:M31;IF(AND(K2>2;L2=2);K30:K32;J30:J33))))));0);0)