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.

Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

Learn how to use Microsoft Excel to calculate the Sharpe ratio, an investing tool used to assess the relationship between risk and return for an asset.

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

You can calculate a bank's capital to risk-weighted assets ratio in Microsoft Excel once you determine its tier 1 and tier 2 capital and its risk-weighted assets.

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.

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.

If you are looking for a way to calculate the weight to height ratio and Body Mass Index in Excel, use this BMI calculation formula.

How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook.