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.

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

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you copy ...