Multiple choice technology

What function is used to make sure that all conditions are true before showing a TRUE answer?

  1. =AND()

  2. =OR()

  3. =If()

  4. =Vlookup()
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The AND function returns TRUE only when ALL its arguments evaluate to TRUE. This makes it perfect for checking that multiple conditions are all satisfied simultaneously. For example, =AND(A1>10, B1<20) returns TRUE only if both conditions are met. OR returns TRUE if ANY condition is true, IF evaluates a single condition, and VLOOKUP searches for values.

Keep practicing — related questions