Excel Video 148 adds the AND function to our collection of logical tests in Excel. The AND function simply evaluates a list of conditions, each separated by a comma. If all of the conditions are true, AND is true. If even one of the conditions is false, AND is false.
Watch Excel Video 148 to see how AND works with IF. You’ll remember IF evaluates a condition and then does one thing if the condition is true and another thing if the condition is false. By using AND as the condition for IF, you can make sure a group of conditions is true and then use IF’s logic to control what happens next.
What if you want IF to act if at least one of the conditions is true? Excel has a function for that. We’ll discuss OR next time.
