Use this code instead of Concatenate function.

[Don Black]

Hello

My formula does not give back any errors, but it does not give me the proper response either.

I need this formula to concatenate the two cells B2 & C2 only of the conditions are met from the "IF".

=IF(AND('AC Details'!C3="training", 'AC Details'!C3="travel"),'AC Details'!B3&" "&'AC Details'!C3,'AC Details'!B3)

 

[Don Black]

I got it i guess I had to use the concatenate

=CONCATENATE('AC Details'!B12," ",'AC Details'!C12,IF(AND('AC Details'!C12="training",'AC Details'!C12="travel"),'AC Details'!B12,""))