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.
