DSSSB · Computer

What will be the result of Formula =AND(A2>1, A2<100) in MS Excel?

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