Help

If blank formula

Solved
Jump to Solution
980 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Matthieu_LABERI
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus
IF(
   AND({Diamètre}, {Hauteur}),
   CONCATENATE("Diamètre : ", {Diamètre}, " cm / ", "Hauteur : ", {Hauteur}, " cm")
)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus
IF(
   AND({Diamètre}, {Hauteur}),
   CONCATENATE("Diamètre : ", {Diamètre}, " cm / ", "Hauteur : ", {Hauteur}, " cm")
)
Matthieu_LABERI
6 - Interface Innovator
6 - Interface Innovator

thanks a lot Kamille