by Jim Gordon MVP <goldkey74@[EMAIL PROTECTED]
>
Apr 29, 2008 at 09:50 PM
Neo@[EMAIL PROTECTED]
wrote:
> 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.
http://mvp.sup****t.microsoft.com/
Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9
