"Rick" wrote:

Mudraker:
That is true.... But if you look carefully, you'll see that there are 2
different paths for the level 3 to take. In both paths, there are a max of
seven nested if's. Levels 1 and 2 are common for both paths. Nowhere in the
manuals or in help, is there a true explaination of the level therory. By the way this is the assembled IF statement, and it works very well. I just wanted an explaination of why it works, if only 7 if's can be in a calculation.

=IF($G5="M",IF(OR(YEAR($B5)=$AU$3,$F5="Full",$F5=" BMP",$F5="CBC",$F5="RVP",$F5="UA"),0,IF($H5="D",IF ($U5="Yes",RollUp!$AU$11,IF($B5=RollUp!$AR$11,0,I F($B5<RollUp!$AR$11,$K5,IF(SUM(Activity!$AM$326+$K 5)<RollUp!$AT$6,$K5,SUM($K5*0.2))))),IF($U5="Yes", RollUp!$AU$12,IF($B5=RollUp!$AR$12,0,IF($B5<RollU p!$AR$12,$K5,IF(SUM(Activity!$V$326+$K5)<RollUp!$A T$4,$K5,SUM($K5*0.2))))))),0)
Rick

"mudraker" wrote:


I could be wrong but I have heard that you can have a max of 7 nested if
statements


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=536904