CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2 ​

Chapter 6: Logical Functions ​

6.1: New Functions ​

• AND: Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE.

• OR: Checks whether any of the arguments are TRUE, and returns TRUE or FALSE.

• NOT: Changes TRUE to FALSE, or FALSE to TRUE.

• IF: Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

  • Nested IF: Using multiple IF statements in one functions to account for multiple conditions.

• VLOOKUP: Looks for a value in a table or a range veryically

  • VLOOKUP What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an approximate or exact match: Indicates as 1/TRUE, or 0/FALSE.

• HLOOKUP: Looks for a value in a table or a range horizontally.

• COUNTIF: Counts the number of cells within a range that meet the given condition.

  • =COUNTIF(Where do you want to look? What do you want to look for?)

• SUMIF: Adds the cells specified by a given condition or criteria.

• AVERAGEIF: s an Excel Statistical function, which calculates the average of a given range of cells by a specific criterion.

6.2: Comparison Operators ​

• >: More than
• <: Less than
• >=: More than or equal to
• <=: Less that or equal to

6.3: Reminder ​

• Excel does not recognize tex
  • When searching for keywords, put keyword between "" delimiters.