Great thanks XOR
I've solved it today morning but actually in different looooong way.
I just wonder how AND function works in this section?
IF(AND(E5>=50,H5>=50,K5>=50,N5>=50,Q5>=50),"Pass in 2nd attempt"
I thought, when AND is used all conditions should be met, not partially like OR.
But in your solution, if E5 and N5 are >=50 it would give TRUE.
So, what is the difference between AND and OR if I use in this IF statement?
|