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.