This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...

Dynamic arrays change the rules for formula output in Excel. When I write a formula that returns a list by default, I need to decide whether I want the result to spill across a range of cells or ...

If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others identify data quickly, recognize trends and even spot ...