View Single Post
 
Old 04-18-2017, 12:47 PM
Abdulmunim Abdulmunim is offline Windows Vista Office 2007
Novice
 
Join Date: Apr 2017
Posts: 5
Abdulmunim is on a distinguished road
Default

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?
Reply With Quote