Excel

Card Set Information

Author:
amijay3
ID:
165068
Filename:
Excel
Updated:
2012-08-05 17:58:58
Tags:
Excel
Folders:

Description:
Excel
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user amijay3 on FreezingBlue Flashcards. What would you like to do?


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

    • =AND(logical1,[logical2])
    • =AND(H5<2000,H5>30000)
  2. =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)
  3. =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.

What would you like to do?

Home > Flashcards > Print Preview