Quote Originally Posted by Aussiebear View Post
What happens if you enter this formula in cell K37?
=If(L70 = 1,"Pass",If(And(B70 =1,L70 = 0),"Fail","DNP"))
Sorry, my mistake, I meant despite L70 being 0, it still makes K37 "Pass." Thanks for catching that