Nested "if" statemenets

[Neo]

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'?

 

[Jim Gordon MVP]

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

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9

 

[JE McGimpsey]

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...

 

[CyberTaz]

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.