Home
Flashcards
Preview
Excel
Home
Get App
Take Quiz
Create
Automatically remove your image background. Try it now!
https://remove-image-background.com
=AND
- Checks whether allarguments are TRUE and returns TRUE if ALL arguments are TRUE.
=AND(logical1,[logical2])
=AND(H5<2000,H5>30000)
=OR
- Checks whether anyarguments are TRUE, and returns TRUE or FALSE. FALSE only if ALL argumentsare false.
=OR(logical1,[logical2])
=OR(H5<20000,H5>25000)
=NOT
- 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.
Author
amijay3
ID
165068
Card Set
Excel
Description
Excel
Updated
2012-08-05T21:58:58Z
Show Answers
Home
Flashcards
Preview