Microsoft Excel Functions: Logical and Lookup Functions (Part 4)
Explore “Logical and Lookup Functions” in this Microsoft Excel Functions lesson. Part 4 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- =AND(First_Logic,Second_Logic)
- Functions Lookup
- LOOKUP Function
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Function | Description
Function | Description AND | Both logic are true then return true Or | One logic is true then return true > | First greater then Second < | First less then second >= | First Greater then or Equal the second <= | First less then or Equal the second IF | Logic is true the return true other wise false Logic Function
=AND(First_Logic,Second_Logic)
=AND(First_Logic,Second_Logic) =OR(First_Logic,Second_Logic) Greater Then ( > ) = First_ Condition > Second_Condition Less Then ( < ) = First_ Condition < Second_Condition =IF(Logic,Truth_Value,Flase Value) (if reference true then truth value else/otherwise false value) Logic Function
Functions Lookup
Functions Lookup Function | Description CHOOSE | Returns a specific value from a list of values supplied as arguments HLOOKUP | Horizontal lookup. Searches for a value in the top row of a table and returns a value in the same column from a row you specify in the table. IF | Returns one value if a condition you specify is TRUE, and returns another value if the condition is FALSE.
IFERROR | If the first argument returns an error, the second argument is evaluated and returned. If the first argument does not return an error, then it is evaluated and returned. INDEX | Returns a value (or the reference to a value) from within a table or range
LOOKUP | Returns a value either from a one-row or one-column range. Another form of the LOOKUP function works like VLOOKUP but is restricted to returning a value from the last column of a range. MATCH | Returns the relative position of an item in a range that matches a specified value. OFFSET | Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
VLOOKUP | Vertical lookup. Searches for a value in the first column of a table and returns a value in the same row from a column you specify in the table.
LOOKUP Function
LOOKUP Function
Review questions and answers
What are the key points about Function | Description?
Function | Description AND | Both logic are true then return true Or | One logic is true then return true > | First greater then Second < | First less then second >= | First Greater then or Equal the second <= | First less then or Equal the second IF | Logic is true the return true other wise false Logic Function
What are the key points about =AND(First_Logic,Second_Logic)?
=AND(First_Logic,Second_Logic) =OR(First_Logic,Second_Logic) Greater Then ( > ) = First_ Condition > Second_Condition Less Then ( < ) = First_ Condition < Second_Condition =IF(Logic,Truth_Value,Flase Value) (if reference true then truth value else/otherwise false value) Logic Function
What are the key points about Functions Lookup?
Functions Lookup Function | Description CHOOSE | Returns a specific value from a list of values supplied as arguments HLOOKUP | Horizontal lookup. Searches for a value in the top row of a table and returns a value in the same column from a row you specify in the table. IF | Returns one value if a condition you specify is TRUE, and returns another value if…
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Function | Description should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.