You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

Explaining How to Calculate Price-to-Earnings Ratio in Excel Assume you want to compare the P/E ratio between two companies, which are in the same sector, using Microsoft Excel.

The acid-test ratio, also known as the quick ratio, measures the liquidity of a company. Learn how to calculate acid-test ratio here.

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

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money. To calculate ROI you ...

Calculating the ratio of selling to asking price is useful knowledge during any transaction that involves a negotiated price.

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.