Skip to main content

Using IF statements

  • January 13, 2020
  • 2 replies
  • 31 views
K

I’m new to coding and trying to get the code below to perform a function if not null. Can someone show me where I’m going wrong with this code line? Thanks in advance!

If({Facebook Embed} is not null, CONCATENATE({Business Name}, " on Social Media"))

    This topic has been closed for replies.

    2 replies

    A
    Forum|alt.badge.img+19
    • AlliAlosa
    • Inspiring
    • January 13, 2020

    Hi there!

    Try this :slightly_smiling_face: 

    IF({Facebook Embed}, CONCATENATE({Business Name}, " on Social Media"))

    The first part of the formula, “IF({Facebook Embed},...” can be read in english as “If {Facebook Embed} is not empty/blank/null”.

      K
      • Ken_Cooper
      • Author
      • Participating Frequently
      • January 13, 2020

      Hi there!

      Try this :slightly_smiling_face: 

      IF({Facebook Embed}, CONCATENATE({Business Name}, " on Social Media"))

      The first part of the formula, “IF({Facebook Embed},...” can be read in english as “If {Facebook Embed} is not empty/blank/null”.


      You are awesome! Thank you so much, it worked… :slightly_smiling_face:

        Terms & ConditionsAccessibility statement