How to Calculate Maximum Sales Price in Excel. You have three ways to calculate sales price in Excel. First, you can apply a flat profit to the cost of the item as a dollar value.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

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

How to Calculate Multiple Cells in Excel. Microsoft Excel is a spreadsheet program used to store and analyze data. While Excel is able to hold both text and numerical data, most of the pre ...

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.

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.

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.

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

Discover what a log-normal distribution is, its financial applications, and how to calculate it, including using Excel for ...