LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 case sensitive problems with New Database Query havrek Excel Discussion (Misc queries) 1 March 7th 08 05:17 PM
Excel 2003 can't do case sensitive sorting! TelcordiaJack Excel Discussion (Misc queries) 3 October 10th 06 09:14 PM
how do i change a case to proper text in excel 2003 BBD Excel Worksheet Functions 1 September 20th 06 01:21 AM
Changing case on mailing lists I receive in Excel 2003? Walt Excel Worksheet Functions 1 July 22nd 05 04:27 PM
does anyone have the excel 2003 tutorial 3 case 4 (ortitiz marine. topgunsaby Excel Discussion (Misc queries) 0 December 10th 04 12:29 AM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"