any limit?
 

i been working with excel and been fond of using the IF function, but even
today, i had not found any excel worksheet function that cannot be
governed/read by the 7 IFs function. Yet I still need to learn and ask our
professional excel users in this forum if the 7 IFs cannot accomodate other
functions.

Excel has a long list of functions for a lot of working categories. Yet the
IF function is not explained clearly about its limitation - limit of
inserting other function - within its formula.

=IF(logical_test,value_if_true,value_if_false).

pls. share your experience to avoid errors for users like me?

any limit?
 

The limit of seven is not unique for IF; it is a general limit for nesting functions.
One formula can have many more than 7 functions, just not nested.
Ways to overcome the limit:

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"p" wrote in message ...
|i been working with excel and been fond of using the IF function, but even
| today, i had not found any excel worksheet function that cannot be
| governed/read by the 7 IFs function. Yet I still need to learn and ask our
| professional excel users in this forum if the 7 IFs cannot accomodate other
| functions.
|
| Excel has a long list of functions for a lot of working categories. Yet the
| IF function is not explained clearly about its limitation - limit of
| inserting other function - within its formula.
|
| =IF(logical_test,value_if_true,value_if_false).
|
| pls. share your experience to avoid errors for users like me?

any limit?
 

"Yet I still need to learn and ask our professional excel users in this forum
if the 7 IFs cannot accomodate other functions."

i also dont know, maybe others?.


"Niek Otten" wrote:

The limit of seven is not unique for IF; it is a general limit for nesting functions.
One formula can have many more than 7 functions, just not nested.
Ways to overcome the limit:

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"p" wrote in message ...
|i been working with excel and been fond of using the IF function, but even
| today, i had not found any excel worksheet function that cannot be
| governed/read by the 7 IFs function. Yet I still need to learn and ask our
| professional excel users in this forum if the 7 IFs cannot accomodate other
| functions.
|
| Excel has a long list of functions for a lot of working categories. Yet the
| IF function is not explained clearly about its limitation - limit of
| inserting other function - within its formula.
|
| =IF(logical_test,value_if_true,value_if_false).
|
| pls. share your experience to avoid errors for users like me?