Anne Troy Wrote:
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/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"msals22" wrote
in
message ...

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


--
msals22

------------------------------------------------------------------------
msals22's Profile:
http://www.excelforum.com/member.php...o&userid=30908
View this thread:
http://www.excelforum.com/showthread...hreadid=506953

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


--
msals22
------------------------------------------------------------------------
msals22's Profile: http://www.excelforum.com/member.php...o&userid=30908
View this thread: http://www.excelforum.com/showthread...hreadid=506953