How to Use If-Then Excel Equations to Color Cells. If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others ...

Logic statements in Microsoft Excel allow you to test the contents of cells to see if they meet your criteria. For example, if a spreadsheet lists sales figures, you can use Excel logic statements ...

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an action based on the result. They are useful for analyzing data, automating ...

This is where the number-crunching fun starts. Learn the ins and outs of the logical formulas that represent the heart of Excel.