If/And with Blanks and Not Blanks

[OctoberFest]

Hi,

I am trying to check if the Cell "vB" has a value or not using 

IF({vB} != BLANK(),"true","false").

But strangely, even blank cells are spitting out the value "true". No clue why. Can anyone help?

[Sho]

The BLANK function is only for returning BLANK, so it is not to be used in comparisons.

In Airtable, this works fine.

IF({vB},"true","false/Blank/null")

[OctoberFest]

Understood, thanks for clarifying. So what can I use for comparisons? There is a greater if-then-statement around the partial formula I mentioned above and I would like to avoid nesting if-thens.

[OctoberFest]

Nevermind, I think I figured it out. I just have to include the plain {vB} variable as it is in the greater if-then-statement. 

[Alexey_Gusev]

Hi,
JFYI, you can use field name only for 'non-emptiness' check,
use FIND('word', {Text}) to check whether text includes word,
can insert single-word field name without brackets, and omit 'action if false'.  For example:

IF(vB,'yes')