Posted to microsoft.public.excel.programming

Toby Erkson[_3_] Toby Erkson[_3_] is offline

external usenet poster

Posts: 24

Using SELECT...CASE with comparison operators?

Can I convert the following IF...THEN statements to a SELECT...CASE?

if wigets = 20 AND wigets < 200 then...
if wigets =200 AND wigets < 400 then...
if wigets = 400 AND wigets < 600 then...

Excel help wasn't too helpful. I tried unsuccessfully to use TO and IS. I
don't think I understand them very well.

Thanks,
Toby Erkson
Oregon, USA
Excel 2002 in Windows XP

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Comparison Operators in formulas	Steve P[_2_]	Excel Discussion (Misc queries)	1	November 5th 09 11:55 PM
Case without Select Case error problem	Ayo	Excel Discussion (Misc queries)	2	May 16th 08 03:48 PM
Comparison Operators on a Toolbar	Teacher in Need	Excel Discussion (Misc queries)	0	October 3rd 06 08:00 PM
Comparison Operators for IF statement.	Shams	Excel Worksheet Functions	1	February 14th 05 03:35 PM
select case help please	Christine Flott[_2_]	Excel Programming	4	July 29th 03 09:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us