2] Calculate ratio in Excel by using the SUBSTITUTE and TEXT functions. Here, we will use the TEXT function to display the result in a fraction, then we will replace the fraction with the ratio by ...