Excel

- Checks whether allarguments are TRUE and returns TRUE if ALL arguments are TRUE.

• =AND(logical1,[logical2])
• =AND(H5<2000,H5>30000)

- Checks whether anyarguments are TRUE, and returns TRUE or FALSE. FALSE only if ALL argumentsare false.

• =OR(logical1,[logical2])
• =OR(H5<20000,H5>25000)

- Changes FALSE to TRUE orTRUE to FALSE 

• =NOT(logical)
• - If Cell I3 has avalue of 89 and you put in the formula =NOT(I3=89) your answer will beFALSE because it is the opposite answer.