Read: How to Calculate Simple Interest in Excel. How do you enter a ratio value in Excel? There is no direct way to show the result as a ratio in Excel. For this, you have to use appropriate formulae.

Investors can calculate a debt service coverage ratio for a company using Microsoft Excel and information from ... B3/C3 Press Enter or Return on your keyboard See the screenshot below for how ...