Question: For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

1. OR(B3=>15,B3<=20)
2. AND (B3>=15,B3<=20)
3. OR(B3>15,B3<20)
4. AND(B3>15, B3<20)

Answer: The correct answer of the above question is Option B:AND (B3>=15,B3<=20)