Formula for if one field is blank then choose another field

[Michelle-T]

Hi all, I’m literally just starting out, but trying to make my primary field choose the correct investor (either personal or corporate). Is there a way to make this work in something like this format:

IF(
{Company Name}!=BLANK(),
{Company Name})
ELSE(
{Last Name})

The first part of the string works, but I can’t get the second part to work. Any suggestions would be greatly appreciated.

[ScottWorld · Accepted solution]

Welcome to the community, @Michelle-T!

There is no “Else” statement in Airtable, and you can also just test for the presence of a field’s value by using its name. So your formula could look like this:

IF(
{Company Name},
{Company Name},
{Last Name}
)

[Michelle-T]

ScottWorld:

IF(
{Company Name},
{Company Name},
{Last Name}
)

OMG thank you! I feel like such a dummy now! that was so easy!!

[Michelle-T]

Hi again, just out of curiosity, can i add the first name field as well? I have been trying, but I can’t make it show up.
Thanks!
Michelle

[ScottWorld]

Here you go:

IF(
{Company Name},
{Company Name},
{First Name} & " " & {Last Name}
)

This documentation might be helpful for you:

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...