hindi ko maintindihan ang problem. pero kailangan mo yata ng conditional statement : type lang ng IF sa cell tapos may lalabas dyan na tooltip e.g : if( condition, true , false )
sample statement. cell1 is at A1 , cell2 at B1 and cell3 is at C1. if cell1 equals cell2 then cell3 equals cell1 otherwise cell2.
type the code at C1: if( A1=B1 , A1,B1)
or if you mean idudugtong yong text or called concatenation e.g "A"+"KO" = AKO. type i think CONCATENATE ,may lalabas naman na tooltip . basahin lang ang syntax