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.

In Microsoft Excel, you can convert a number into a fraction using the Fraction format. Learn how to display Numbers as Fractions in Excel.

Entering fractions in Microsoft Excel isn’t exactly intuitive, but it is easy. Learn how to enter and display fractions as either fractions or as decimal values.

Once you determine your asset and liability totals, calculating the current ratio in Excel is very straightforward, even without a template.