More functions
 

How do I add more functions when I get the error "Too many functions"?

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

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

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

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

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