Which formulae would result in TRUE if C3 is less than 14 and D4 is less than 200?

(a)=AND(C3>14,D4>20)
(b)=AND(C3>14,C4< 200)
(c)=AND(C3>14, D4< 20)
(d)=AND(C3< 14,D4,200)

Solution

d) =AND (C3< 10, D4,200)