Multiple (more than 7) IF Formula

[marihouse]

Is there a way to have more than 7 "IF" statements in a formula? If so, how?!

 

[Zack Barresse]

no, only 7 nested. alternatives do exist, like using vlookup or hlookup and such, or the AND and OR functions.

 

[bjwillingham]

You may also try defininin some of the conditions in a named formula.

 

[Iridium]

Is there a way to have more than 7 "IF" statements in a formula? If so, how?!

Unfortunately you can't get around the limit of 7 nested if statements.

Have a look at J-Walk: Alternatives to nested IF functions

HTH

 

[atmospheric]

Just to go back a few threads in this discussion, Everyone agrees that the IF statement can only accomodate 7 IF's (Nested IF statement), but I have on occasion had to use IF for 9 or more conditions. Like so:

[Cell A1] = Nested IF statement containing 7 conditions but make the final "Condition if false", "" , (two apstrophies) in other words nothing.

Do the same to cell [A2] and cell [A3] if required. (Total of 21 IF's)

Then simply =A1&A2&A3 in the required cell to achieve your answer.

If the correct condition is not found in A1, the result is nothing, so adding nothing to cell A2 equals A2. Similarly if the result is not in A2, the answer is in A3. For correctness, make the final pair of apostrophies in A3 into a statment such as "Item not found"

It might be clumsy, but it works!

But, as my esteemed superiors say, there are easier ways!!!

 

[Zack Barresse]

iridiums post will probably generate the best alternatives, as at the j-walk website. using the ampersand - concatenate - is useful to keep the functions in a single cell.

alternatively atmospheric's idea is great for sharing multiple if statements with various other cells. i.e. multiple other formulas only needing particular parts of the if statements. this would seem to be the most dynamic, to me.

good stuff though.

 

[jimrward]

hi can you post the multiple IF's you have so far, either in reply or using Colo's utility, and a broader description in your own words of what you are trying to achieve, as I have found on this site there are many ways to skin a cat, so to speak