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 ...
In cell B5, input the formula "=B3/B4" to divide your assets by your liabilities, and the calculation for the current ratio will be displayed. Example of Calculating the Current Ratio in Excel Let ...