How do I create an If-then-else function in which If(certain value)
equals either one of a specified list of 10 values

The issue is not how the if then else works, the issue is how to
compare with a list of several options (say 20 values)?

The nested option does not work, since one cannot nest 8 statements.

Thanx for the help!


--
broer konijn
------------------------------------------------------------------------
broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402
View this thread: http://www.excelforum.com/showthread...hreadid=551311