Hey,
I need to create a formula something like this:
If field_1 = “text_A”, then;
If field_2> field_3, “Text_B”, “Text_C”
Otherwise “Text_D”
I don´t know how to do it and I couldn´t find from community or google…
Anybody?
Thanks
//Mikko
Page 1 / 1
This is a simple nested IF() use case, or a use case for AND(). Search for “nested if” for more examples.
Your example formula can be interpreted one of two ways. I’m not sure if you want to output a semicolon if the first input is true. If so:
IF(
{field_1} = "text_A",
";",
IF(
{field_2} > {field_3},
"Text_B",
"Text_C"
)
)
If not, then:
IF(
AND({field_1} = "text_A", {field_2} > {field_3}),
"Text_B",
"Text_C"
)
This is a simple nested IF() use case, or a use case for AND(). Search for “nested if” for more examples.
Your example formula can be interpreted one of two ways. I’m not sure if you want to output a semicolon if the first input is true. If so:
IF(
{field_1} = "text_A",
";",
IF(
{field_2} > {field_3},
"Text_B",
"Text_C"
)
)
If not, then:
IF(
AND({field_1} = "text_A", {field_2} > {field_3}),
"Text_B",
"Text_C"
)
Welcome to the Airtable community!
Here’s another possible interpretation.
IF(
{field_1} = "text_A",
IF(
{field_2} > {field_3},
"Text_B",
"Text_C"
),
"Text_D"
)
Thank you! 
it works nice!
//Mikko
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.