Skip to main content

Hi community,

I need your help.


I have a concatened formula who find 2 result on 2 colums + text

I just want to add this condition : if you have 1 or 2 result missing, display a bank field.


This is the formula :

CONCATENATE("Diamètre : “,{Diamètre},” cm / ",“Hauteur : “,Hauteur,” cm”)


The 2 column : “Diamètre” and “Hauteur”


Thank’s for your help


Matthieu

IF(
AND({Diamètre}, {Hauteur}),
CONCATENATE("Diamètre : ", {Diamètre}, " cm / ", "Hauteur : ", {Hauteur}, " cm")
)

thanks a lot Kamille


Reply