The easier way is to use a lookup, the most common being the Vlookup
function.

Regards,
Fred

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