This formula would result in 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 formula =AND(C4<10, D4<100) is the accurate representation of the condition specified.
- It ensures that both C4 is less than 10 and D4 is less than 100 for the result to be TRUE.
- This means that if both conditions are met, the formula will return TRUE; otherwise, it will return FALSE.