Calculation field help!
Hi there, I'm trying to work on a calculation field for a database. I have three fields for dimensions - height, width and depth. These fields are pulled into a calculation field in the database for easy copying, pasting, emailing etc. The issue is. Sometimes there won't be a depth. So how do I remove the formatting if depth is empty? This is what I have but it is not working correctly. Images attached. THANK YOU
Artist &¶ &TextStyleAdd(Title;Italic) &¶ & Date &¶ &Medium &¶ & Heightcm & If (IsValid ( Heightcm ) ; " x " ) & Widthcm & If (IsValid ( Depthcm ) ; " x " ) & Depthcm & " " & "cm" & ¶ & Edition Number & ¶ & Inventory # & ¶ & ¶ & ¶