AND function

Use the AND function, to determine if all conditions in a test are TRUE or not.

=AND(logical1,logical2,……)

Example
If the Score is greater than 50 and less than 90, the AND function returns “True”, else it returns “False”.
=AND(B2>50,B2<90)

• Type “=AND(”
• Click “fx” in the formula bar.
• In “logical1“, click on cell “B2” then type “>50”
• In “logical2“, click on cell “B2” then type “<90”
• Click on “OK”
• Drag from “C2 to C8”