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 ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

Format hierarchical financial data using formula-based conditional formatting rules. Build detailed Excel P&L layouts that ...

Microsoft Office has a number of comparison operations so you can check if a value is greater than, equal to or less than another value using the standard greater than, less than and equal symbols.

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight the top ...

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don’t worry–a simple conditional function can handle the request. Subtotals are common in a lot of Excel ...

Conditional Formatting in Excel can be considered a valuable utility that can help visually enhance the data analysis and presentation in the spreadsheet by applying particular formatting based on pre ...