View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajula Rajula is offline
external usenet poster
 
Posts: 53
Default tedious If & or statement

I have a tedious if statement to be made. What is an easier way of doing it.

If B2 is a or b or c or d or e or f, then a2 is XX
if B2 is g or h or i or j, then a2 is YY
if b2 is k or l or m or n or p, then a2 is ZZ
if b2 is q or r or s or t then a2 is ab
..
..
..
..
..
Is there a way or writing this in a if/or statement??