Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# Multiple Columns (3) Nested IF

Topic Labels: Formulas
Solved
827 3
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi All,

I am trying to go around this nested formula and hope someone could help me try understand why is not working.

I have three {columns} that indicate if a condition is either 1 or 0.

So:
column 1 can be 1 or 0
column 2 can be 1 or 0
column 3 can be 1or 0

I have a fourth formula column where I want to indicate the following:

IF column 1,2,3 are all 1 then show “status A”
IF column 1,2 are 1 and 3 is 0, then show “status B”,
IF column 1,2,3, are 0, then show " status C"

I have tried this formula but it wont go through:

IF(
OR(
FIND(“1”, {column1}
),
FIND(“1”, {column2}
),
FIND(“1”, {column3}
),
),
“status A”,
IF(
OR(
FIND(“1”, {column1}
),
FIND(“1”, {column2}
),
FIND(“0”, {column3}
),
),
“Status B”,
IF(
OR(
FIND(“0”, {column1}
),
FIND(“0”, {column2}
),
FIND(“0”, {column3}
),
),
“Status C”,
)

Thanks for whoever takes time to help out with this.

1 Solution

Accepted Solutions
5 - Automation Enthusiast

I thing I have solved it :laughing:

IF(A2=0,”STATUS B”,IF(AND(A2=0,A3=0),”STATUS A”,STATUS C”))

Sometimes you pursue a direction to find a solution and miss the easier way!

Leave here for reference :slightly_smiling_face:

Really great community btw.

3 Replies 3
5 - Automation Enthusiast

I thing I have solved it :laughing:

IF(A2=0,”STATUS B”,IF(AND(A2=0,A3=0),”STATUS A”,STATUS C”))

Sometimes you pursue a direction to find a solution and miss the easier way!

Leave here for reference :slightly_smiling_face:

Really great community btw.

18 - Pluto

Welcome to the community, Gio! :grinning_face_with_big_eyes: Nice work on the solution! I’m a little confused why your field names don’t appear to match with the criteria you listed in your first post, but hey, you know your fields. :winking_face:

Just to toss this out there, this could also be done with the SWITCH function. It wouldn’t be any shorter, but maybe a hair more clear. Going from your initial criteria:

…and naming the fields `{C1}`, `{C2}`, and `{C3}`, it would look like this:

``SWITCH(C1 & C2 & C3, "111", "Status A", "110", "Status B", "000", "Status C")``
5 - Automation Enthusiast

Thanks Justin, that is very helpful.

Hope to contribute more to this awesome community.