View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alex Alex is offline
external usenet poster
 
Posts: 6
Default Case Statements in Excel 2003

Stupid question, but is it possible to do a Case statement in Excel
2003? I can do an IF with no problem, but I need to test a field to
see if it meets about a dozen criteria, and it freaks out if I nest
more than 5 IF statements.

I've looked this up and found a few folks doing this in VB Script, but
given I've never done VBS in Excel, I don't even know where to begin
on that front if that's the only way.

Thanks in advance for any suggestions --

Alex