Microsoft Excel Lesson 6 – If function, nested if function, AND function

In this lesson we talk about 3 more decision making functions in Excel – the IF function, which lets Excel output data based on whether the input condition is true or false, the nested if function (an If function inside another if function), and the AND function, which tests whether 2 or more conditions are both/all true.