 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / April 2008Nested "if" statemenets
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: intel Is there any way of having more than 7 "if" statements in a 'nest'? > Version: 2004 > Operating System: Mac OS X 10.5 (Leopard) > Processor: intel > > Is there any way of having more than 7 "if" statements in a 'nest'? Hi, The exact number of nested IF statements depends on the contents of the IF. A simple IF can handle 13 nests in a cell. The trick is that you can use the result of an IF from one cell within the IF of another cell. Effectively, there is no limit to the number of IF statements you can nest if you chain them together like this. -Jim  SignatureJim Gordon Mac MVP MVPs are independent experts who are not affiliated with Microsoft. http://mvp.support.microsoft.com/ Visit my blog http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9 > Version: 2004 > Operating System: Mac OS X 10.5 (Leopard) > Processor: intel > > Is there any way of having more than 7 "if" statements in a 'nest'? In general, the need for more than 7 IF()s can be more efficiently handled using Lookups or Calculations. Post your conditions if you need help setting them up... In addition to the suggestions from Jim & John you can also consider the the use of AND, OR, & NOT functions in order to handle multiple conditions more efficiently. SignatureHTH |:>) Bob Jones [MVP] Office:Mac > Version: 2004 > Operating System: Mac OS X 10.5 (Leopard) > Processor: intel > > Is there any way of having more than 7 "if" statements in a 'nest'? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.