Do not limit the number of function nested in one formula.

[Guest]

When I put more than 7 function in one formula Excel does not accept this,
because the limit of functions nested in one formula is 7.

I think that the number of functions nested in one formula should be without
limit.

Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...0b609a4&dg=microsoft.public.excel.crashesgpfs

 

[Guest]

Just split your argument over several columns

 

[Ken Wright]

Usual issue is incorrect use of nested IFs when a VLOOKUP or similar would
be far more suited to the task.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[vandenberg p]

Hello:

Let's see, "Without limit" would mean infinite, can you afford the RAM for
such a formula? It would cost an infinite amount, is that within your
budget? Even the speed of light has a limit.

Pieter Vandenberg


: When I put more than 7 function in one formula Excel does not accept this,
: because the limit of functions nested in one formula is 7.
:
: I think that the number of functions nested in one formula should be without
: limit.
:
: Thanks!

: ----------------
: This post is a suggestion for Microsoft, and Microsoft responds to the
: suggestions with the most votes. To vote for this suggestion, click the "I
: Agree" button in the message pane. If you do not see the button, follow this
: link to open the suggestion in the Microsoft Web-based Newsreader and then
: click "I Agree" in the message pane.

: http://www.microsoft.com/office/com...0b609a4&dg=microsoft.public.excel.crashesgpfs