Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Running IF function if fieldvalue is correct

Topic Labels: Formulas
Solved
Jump to Solution
223 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Thank you! :pray:

it works nice!

//Mikko