VB Next?

[msals22]

I have reached the maximum threshold of 8 IF statements in 1 cell bu
have more I need to enter. I think I should now use some VB code t
enter the entire list of conditions I have. I am really inexperience
when it comes to VB so can someone get me started on the syntax? Than
you

 

[Anne Troy]

Likely, you can create a table of IF in one column, THEN in the second
column, and use a vlookup:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[SteveG]

If you outline what it is you are trying to do, maybe there is a
alternate solution to VB. There are ways to shorten the number o
nested if statements.


Stev

 

[msals22]

Likely, you can create a table of IF in one column, THEN in the second
column, and use a vlookup:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

in
message news:[email protected]...

Anne-
After a little trial and error I got it...thanks!

 

[Anne Troy]

You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com