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.

How to Calculate IRAs on Excel. Individual Retirement Accounts or IRAs are used to help you invest and save funds for retirement. IRAs are designed to allow you to invest a specific amount of ...

How to Calculate the Percent of Total Sales in Excel. Monitoring sales revenue allows you to track your business' profit, but equally important is understanding where those revenues are derived ...

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

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.

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.