View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ellebelle ellebelle is offline
external usenet poster
 
Posts: 34
Default avoid embedded if statements

Hello,

Is there a quick way to do multiple if statements rather than using an
embedded if statement?

I have the following:

If A1 = 1 then write carpet, If A1 = 2 then write couch, If A1 = 3 then
write table and so on.

Is there an easier way?

Ellen