A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

nested formula help needed



 
 
Thread Tools Display Modes
  #1  
Old October 14th, 2003, 04:17 PM
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.