How many levels of an IF statement is allowed within a Nested IF?

R

Rick

I need to test different issue's within a cell. Here is an example. When I
speak of levels it is in reference to actual levels not the number of IF's.

=IF($G5="M","T1",0)
"T1"
IF(OR(YEAR($B5)=$AU$3,$F5="Full",$F5="BMP",$F5="CBC",$F5="RVP",$F5="UA"),0,"F2")
" F2" IF($H5="D","T3","F3")
"T3" IF($U5="Yes",$AV326,"F4")
"F4" IF($B5>RollUp!$AR$15,0,"F5")
"F5" IF($B5<RollUp!$AR$15,$K5,"F6")
"F6" IF(SUM(Activity!$AM$326+$K5)<RollUp!$AT$6,$K5,SUM($K11*0.2))
 
K

kassie

Not at all clear what you are trying to achieve here! What are "F2" etc
referring to? Are these different cells, or are these different values? are
you trying to say that if the result of your IF statement is "F2", you want
further analysis on the result, or what? I suggest you provide a bit more
detail, so that your question can be understood.
 
R

Rick

Kassie:
The "T1" or "F1" and so on, is the True or False condition of the parent if.
So I put those indicators in from of the "if statement" so that you can tell
by assembling the nested if where the next if was to be placed. The "T3" and
"F3" level is where I am trying to find out from someone who has expert
knowlege of VB which excel is written in. If when one says level 3 of a
nested if and there are 2 ways to go,(True, and False). If one path is the
true, for level 4 thru 7, and also is the path for false, leve 4 thru 7?
IF($H5="D","T3","F3") is a true split of the nested if.
Thanks
Rick
 
R

Rick

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

Rick

Rick said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top