Which formula is true if C4 is less than 10 and D4 is less than 100?
Answer & explanation
Correct answer: option 4
The correct answer is option 4- =AND(C4<10, D4<100).
The AND function returns TRUE only if all the conditions inside it are TRUE.
The formula to be true when:
- C4 is less than 10 (C4<10)
- D4 is less than 100 (D4<100)