Which formulae would result in TRUE if C4 is less than 10 and D4 is less than 100? 

(A) =AND(C4>10, D4>10) 

(B) =AND(C4>10, C4<100)

(C) =AND(C4>10, D4<10) 

(D) =AND (C4<10, D4,100)

(D) =AND (C4<10, D4,100)