View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrea54 Andrea54 is offline
external usenet poster
 
Posts: 2
Default Use multiple functions in single formula

I am attempting to generate a formula that states if the data in cell A1=A2,
then merge the data in cells C1&C2 separated by a comma

Cannot combine both =IF and =CONCATENATE in the same formula
--
Andrea54