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.