Help

Running IF function if fieldvalue is correct

Topic Labels: Formulas
Solved
Jump to Solution
1465 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mikko_Mantere1
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions

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"
)

See Solution in Thread

3 Replies 3

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"
)
Mikko_Mantere1
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! :pray:

it works nice!

//Mikko