This formula would result in TRUE if C4 is less than 10 and D4 is less than 100. |
= AND (C4 > 10, D4 > 10) = AND (C4 > 10, D4 >100) = AND (C4 > 10, D4 = 100) = AND (C4 < 10, D4 < 100) |
= AND (C4 < 10, D4 < 100) |
The correct answer is Option (4) → =AND (C4 < 10, D4 < 100)
|