View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson[_3_] Toby Erkson[_3_] is offline
external usenet poster
 
Posts: 24
Default 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