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.

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.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

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.

One of the most important financial ratios, and one carefully regarded by regulators, is the capital-to-risk weighted assets ratio, or capital adequacy ratio, of a bank.