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 the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

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

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

An example would be =2^3 + 4. In this case, Excel calculates the exponent first, resulting in 2^3=8. After calculating the exponent, it adds 4 to the result, leading to a final value of 12.

Learn about the book value of equity per share, what it measures and how to calculate a company's book value of equity per share using Microsoft Excel.

To determine the value of a bond today—for a fixed principal (par value) to be repaid in the future—we can use an Excel spreadsheet.

Everyone likes a bonus, but sometimes calculating one can be a bit complicated--at first. Here's how to calculate the amount in Microsoft Excel that you or your staff will get paid.