I asked a similar question a while ago and got some good answers.
In reply to Re: Better rewrite of multiple ifs by bradcathey in thread Better rewrite of multiple ifs by Nik