Provides two sample macros about how to use the IF THEN ELSE statement and the SELECT CASE statement in Excel 2000.
support.microsoft.com