Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

Original Price * (1 – Percentage Decrease). If you need to reverse a discount or calculate the original price from a tax-inclusive amount, divide the adjusted price by: (1 – Percentage Decrease).

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

An ideal way to calculate inflation-adjusted prices is by collecting data on a particular indicator, preferably a consumer price index.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.