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

  • OR(B3=>15,B3<=20)
  • AND (B3>=15,B3<=20)
  • OR(B3>15,B3<20)
  • AND(B3>15, B3<20)

The correct answer is:

  • AND (B3>=15,B3<=20)

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers