View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lance Hebert[_2_] Lance Hebert[_2_] is offline
external usenet poster
 
Posts: 15
Default IF Function and Concatenation

I have three columns that I am trying to Concatenate. I only need to combine
two columns at a time, but I want to be able to Concatenate say Column C and
Column A if Column D=4, 5 or 6 or if Column D=11, 12 or 13 than Column C and
Column B would be Conceatenated.

Is this possible? I know how to put in the IF function, but can the IF
function have a number of possibilites in it?

Thanks so much for all of your help.