Advertisements
Advertisements
Question
Which formulae would result in TRUE if C3 is less than 14 and D4 is less than 200?
Options
=AND(C3>14,D4>20)
=AND(C3>14,C4<200)
=AND(C3>14, D4<20)
=AND(C3<14,D4,200)
MCQ
Solution
=AND(C3<14,D4,200)
shaalaa.com
Other Useful Functions - Logical Function
Is there an error in this question or solution?