=IF(ISBLANK(J23),"",IFS(AND(K23=$O$16,J23>=10),OR(AND(J23="OL",ISBLANK(K23),"PASS","FAIL"))))
I have a formula where if two cells are true (in this case greater/equal to J23 + K23 [>=10 Megaohms]), they return a PASS. Otherwise they FAIL. However, if one of those cells (J23) contains "OL", and K23 is blank, I want the formula to return a PASS. If the former is true I get a PASS/FAIL as required, but if the latter is true I receive an #NA instead of PASS. I've tried this way: =IF(ISBLANK(J23),"",IFS(AND(K23=$O$16,J23>=10),"PASS","FAIL",OR(AND(J23="OL",ISBLANK(K23),"PASS","FAIL")))) , but then I get #VALUE
Is there a correct way to do this or would I have to resort to VBA code? I'm trying to stay away from VBA in this instance.