PRDV006: Spreadsheets II: Formatting and Functions

The AND function tells you if more than one set of conditions are met. If all conditions in a set are met, you get the output TRUE. If any condition is not met, you get the output FALSE. For example, you can use the AND function to determine if a student passed both the midterm and final exam in a course. Watch this tutorial for another example using the AND function.