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.

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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.

Understand the dividend payout ratio, how it differs from the dividend yield, and how it can be calculated from a company's income statement.

Several basic templates are available for Microsoft Excel that make it simple to calculate production costs.

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.

Investors use the dividend payout ratio to understand how much of a company’s income is paid out as dividends. Learn more about the dividend payout and how to calculate it.

How to Calculate Fluctuations in Excel. Calculating data fluctuations-- also called variance -- is a multi-step process that requires total accuracy. Excel 2010 provides two basic formulas for ...