To use Excel to calculate the current ratio, input the current assets into one cell, the current liabilities in an adjacent cell, and the formula "=(Cell 1)/(Cell 2)" The current ratio is a ...

Once you have determined your asset and liability totals, calculating the current ratio in Excel is very straightforward ... In cell B5, input the formula "=B3/B4" to divide your assets by ...