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

Use multiple functions in single formula
 

hi
try this
=IF(A1=A2,C1&", "&C2,0)

regards
FSt1

"Andrea54" wrote:

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

Use multiple functions in single formula
 

=IF(A1=A2,C1&","&C2,"")

You can have two functions, you just use one =.

--
__________________________________
HTH

Bob

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

Use multiple functions in single formula
 

Worked like a charm, thank-you very much!
--
Andrea54


"FSt1" wrote:

hi
try this
=IF(A1=A2,C1&", "&C2,0)

regards
FSt1

"Andrea54" wrote:

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