Nested statements with IF, AND, OR

[Pika735]

BC>10 OR CB<10% OF TS) TRUE "Pass"
BC>10 OR CB<10% OF TS) FALSE "Fail"
BC<10 OR CB>10% OF TS) FALSE "Pass"
BC<10 OR CB>10% OF TS) TRUE "Fail"

Trying to get a nested IF (AND (Or statement to work, and I keep getting errors. I also tried IFS, with the same result
These are formaulas I need to combine into one.

IF((A3/C3)<10%,AND(D3="True","Pass", "Fail")

IF(B3>10,AND( D3="True", "Pass", "Fail")

IF((A3/C3)>10%,AND(D3="True","fail", "Pass") IF(B3<10, AND (D3="TRUE", Fail", "Pass")

 

[6StringJazzer]

The first four lines of your post don't make any sense.

I see what you are trying to do with your other four formulas but the syntax is wrong.

You also have a logic problem if you want these all to be combined into one formula. You have contradictory conditions. You first have to work out the logic you want before we can address what formulas will implement that logic.

What result do you want if:

A3/C3<10% AND B3<10 AND D3=True
The first formula says this should be Pass but the fourth formula says this should be Fail.

A3/C3>10% AND B3>10 AND D3=True
The second formula says this should be Pass but the third formula says this should be Fail.

What do you want to happen if A3/C3 = 10%? What if B3=10?

 

[Pika735]

The first four lines of your post don't make any sense.

I see what you are trying to do with your other four formulas but the syntax is wrong.

You also have a logic problem if you want these all to be combined into one formula. You have contradictory conditions. You first have to work out the logic you want before we can address what formulas will implement that logic.

What result do you want if:

A3/C3<10% AND B3<10 AND D3=True
The first formula says this should be Pass but the fourth formula says this should be Fail.

A3/C3>10% AND B3>10 AND D3=True
The second formula says this should be Pass but the third formula says this should be Fail.

What do you want to happen if A3/C3 = 10%? What if B3=10?

so the above lines are the criteria, so here is the explaination break down:

BC>10 OR CB<10% OF TS) AND $A3 =TRUE then "Pass"
BC>10 OR CB<10% OF TS) AND $A3 =FALSE then "Fail"
BC<10 OR CB>10% OF TS) AND $A3= FALSE then "Pass"
BC<10 OR CB>10% OF TS) AND $A3 =TRUE then "Fail"

BC is the column numeric value
CB is the column numeric value that would be expressed like =IF ((CB/TS)<10%, "Pass", "Fail")

 

[6StringJazzer]

These formulas have a right ) but no left (.
What are BC, CB, and TS? "Column numeric value" does not not mean anything if we don't know what cell you are talking about.
These formulas do not seem to have anything to do with the other formulas you showed.

 

[Pika735]

These formulas have a right ) but no left (.
What are BC, CB, and TS? "Column numeric value" does not not mean anything if we don't know what cell you are talking about.
These formulas do not seem to have anything to do with the other formulas you showed.

here is better version

CB	BC	TS	Account state	Decision
300	15	1500	TRUE	Pass
300	15	1500	FALSE	Fail
300	5	1500	TRUE	Fail
300	5	1500	FALSE	Pass
100	5	1500	TRUE	Pass
100	5	1500	FALSE	Fail
100	15	1500	TRUE	Pass
100	15	1500	FALSE	Fail
	Account state
BC>10 OR CB<10% OF TS)	TRUE	"Pass"
BC>10 OR CB<10% OF TS)	FALSE	"Fail"
BC<10 OR CB>10% OF TS)	FALSE	"Pass"
BC<10 OR CB>10% OF TS)	TRUE	"Fail"

IF(AND(OR ((CB/TS)<10%, AS="TRUE", BC>10, AS="TRUE", "Pass","FAIL"))

 

[6StringJazzer]

Your conditions are contradictory

Conditions	Account state	Result
BC>10 OR CB<10% OF TS)	TRUE	"Pass"
BC>10 OR CB<10% OF TS)	FALSE	"Fail"
BC<10 OR CB>10% OF TS)	FALSE	"Pass"
BC<10 OR CB>10% OF TS)	TRUE	"Fail"

Suppose you have these three conditions:

BC>10, CB>10% of TS, Account state=TRUE

This set of conditions matches both of the highlighted conditions above. One is Pass and one is Fail. You can't have a set of conditions that is both Pass and Fail.