I have an existing formula (which I didn’t write), which calculates the statements in BLACK.
=IF(AND(A4="BIN TO BIN", B3=B4,A3="BIN TO BIN",LEN(F4)>=4,OR(AND(OR(RIGHT(F3,1)="A", RIGHT(F3,1)="B", RIGHT(F3,1)="C", RIGHT(F3,1)="D"), OR(RIGHT(F4,1)="A", RIGHT(F4,1)="B", RIGHT(F4,1)="C", RIGHT(F4,1)="D")), AND(ISNUMBER(VALUE(RIGHT(F3,1))), ISNUMBER(VALUE(RIGHT(F4,1))))))=FALSE,"",TRUE)
I need to add the condition in RED, but I’m unsure how to go about it.
Thanks for your help.
>Solution :
=IF(
OR(
AND(
A4="BIN TO BIN", B3=B4, A3="BIN TO BIN",
LEN(F4)>=4,
OR(
AND(
OR(
RIGHT(F3,1)="A", RIGHT(F3,1)="B", RIGHT(F3,1)="C", RIGHT(F3,1)="D"
),
OR(
RIGHT(F4,1)="A", RIGHT(F4,1)="B", RIGHT(F4,1)="C", RIGHT(F4,1)="D"
)
),
AND(
ISNUMBER(VALUE(RIGHT(F3,1))), ISNUMBER(VALUE(RIGHT(F4,1)))
)
)
),
AND(A4="BIN TO BIN", A3="BIN TO BIN", B3=B4, F3="FLOOR")
)=FALSE,
"",
TRUE
)