This article shows you how to use the IF function, as well as the AND, OR, and NOT functions, to create conditional formulas in Excel.
office.microsoft.com