Skip to main content
Solved

Looking for a field that is "not empty" in an if statement

  • January 28, 2020
  • 2 replies
  • 815 views
Forum|alt.badge.img

I’m sure it’s here or obvious, but I’m not sure what to search for. I simply want a formula that says:

If Field A is not empty, then 1 else 2.

Sorry if it’s obvious.

Thanks.

Best answer by Moe

IF(A!=BLANK(),1,2) or IF(A=BLANK(),2,1) it’s the same thing.

View original
    This topic has been closed for replies.

    2 replies

    Forum|alt.badge.img+15
    • Moe
    • Inspiring
    • Answer
    • January 28, 2020

    IF(A!=BLANK(),1,2) or IF(A=BLANK(),2,1) it’s the same thing.

      Forum|alt.badge.img+20
      • Jason11
      • Inspiring
      • January 28, 2020

      IF(A!=BLANK(),1,2) or IF(A=BLANK(),2,1) it’s the same thing.


      Great suggestions @Moe! Another route you can take is:

      IF({Field A}, 1, 2)

        Terms & ConditionsAccessibility statement