DSSSB · Computer

When will the result of formula =AND(A2>1, A2<100) be TRUE in MS Excel?

  1. FALSE if A2 is >100 and <1, TRUE otherwise.
  2. FALSE if A2 >1 and <100, TRUE otherwise.
  3. TRUE if A2 >1 and <100, FALSE otherwise.
  4. TRUE if A2 is >100 and <1, FALSE otherwise.
Answer and detailed solution are available in the protected study screen.
Register or login to attempt