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
|