Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF statement.

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.

Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change.