Hi

=IF(wigets <20;"";CHOOSE(INT(wigets /200)+1,"A","B","C","D"))


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


"Toby Erkson" wrote in message
...
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