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.

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

Many use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional functions are the smarter, hidden-in-plain-sight option. They handle complex ...

Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to inventory levels. If you find yourself in a situation where you ...