- IF Function Examples 1
View an example of MS Excel Spreadsheet’s IF Function used effectively comparing Sales Tax Rates between cities.
- IF Function Examples 2
View demonstrations of MS Excel Spreadsheet’s IF Function employed effectively, providing a simple rating for a Blood Pressure reading.
- IF Function Examples 3
Watch a demonstration of Excel Spreadsheet’s IF Function used effectively, building a Complete Name from a Last Name, First Name, and optional Middle Name.
- IF Function Examples 4
View examples of MS Excel Spreadsheet’s IF Function used effectively to extract “First Names” and optional “Middle Names” from “Complete Names.”
- IF Function Challenge 1
Challenge yourself to develop an Excel IF Function correctly, in a context providing data on Median Income and Median priced housing.
- Nested IF Function Strategy
Learn a strategy for developing Nested IF Function formulas. You can provide X possible outcomes by nesting X-1 IF Functions.
- Nested IF Function Examples 1
View an example of four Excel IF functions, NESTED to provide five different possible outcomes to a blood pressure reading.
- Nested IF Function Example 2
View an example applying a strategy for developing Nested Excel If functions, in the context of making a decision with three possible outcomes.
- Nested IF Function Challenge 1
Challenge yourself to develop an appropriate nested IF function for a decision with three possible outcomes.
- AND() Function Example 1
View an example of the AND function used to compare the Poverty Rates in two different cities with the US rate.
- AND() Function Challenge 1
Challenge yourself to apply the AND() function appropriately in a spreadsheet using logical functions to compare median income and housing cost values.
- OR() Function Example 1
View an example of the OR function used to compare poverty levels in two cities with the US level of poverty.
- OR() Function Challenge 1
Challenge yourself to apply the OR() function appropriately in a spreadsheet using logical functions to compare median income and housing cost values.
- Introduction to Logical Type Functions
An introduction to Excel logical functions IF(), AND(), and OR(), examining real data related to Monterey County cities and the US.
