How to Use Logic Statements in Excel. 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 ...

How to use a formula to suppress 0 in a cell in Excel When using an expression that might return a zero, you can wrap that expression in an IF () function to suppress a zero result.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.