If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
nested formula help needed
My experience is Yes, you are limited to seven nested
functions. But my question is, do the functions really need to be nested? I ask this because I received the same message recently and found that in my case I was nesting the functions when I didn't need to. Once I built the statement correctly without nesting I put in well over 20 calculations in the one cell. One way I overcame the seven nested function rule was to build multiple cells each doing seven nested functions. The final cell then used the results of the others -----Original Message----- This is what the help menu tells me. "Nest no more than seven functions You can enter, or nest, no more than seven levels of functions within a function. Learn about creating nested functions." I was curious if anyone could tell me how to write a IF statement with more than seven functions? Is it even possible? Is there a way to combine functions to give the same effect? I am trying to write one with approximately 25. Any help would be greatly appreciated. I have tried just about everything and am very stumped. Thanks. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
Thread Tools | |
Display Modes | |
|
|