Forum Discussion

Copper Contributor

Jul 07, 2023

IF AND … unless???

Current formula; =IF(AND(B17=“Yes”,B18>2.9,B19=“Yes”,OR(B21>19,((B20>24)*(B20<50))),B25>0),”Yes”,”No”) In essence returning a yes/no response to test the suitability of a candidate based on info...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jul 07, 2023

KLNY152

Perhaps

=IF(
    B18 > 2.9 + N("Long part"),
    IF((B17 = "Yes") * (B19 = "Yes"), "Yes", "No"),
    IF(
        OR(
            B21 > 19,
            (B20 > 24) * (B20 < 50)
        ) * (B25 > 0), "Yes", "No")
)