real exchange rate formula doubt Real exchange rate formula is the exchange rate multiplied by the ratio of two prices.

what does this ratio actually imply? What is the rationale behind taking the ratio?
The ratio of relative prices $P^*/P$, where $P^*$ is foreign and $P$ home price level respectively,  is used in order to adjust the nominal exchange rate for changes in relative price levels in two countries. I think a good way of understanding it is to use analogy with real GDP. A real GDP $Y_r$ will be defined as: $Y_r = Y_n/P$ where $Y_n$ is nominal GDP where we would divide by $P$ in order to adjust for the effect of inflation (change in price level).
The real exchange rate is basically the same concept you are trying to adjust the nominal exchange rate for changes in price level, but you cannot just divide by $P$ because then you would be ignoring the changes in foreign price level.
You can see this more clearly if you look at the equation in terms of inflation (as in Copeland's Exchange Rates and International Finance textbook). Start with the definition for real exchange rate:
$$Q=S\frac{P^*}{P}$$
where, $Q$ is the real exchange rate and $S$ nominal exchange. Now take logs of the variables and to clean up the expression I will be using lowercase letters to denote logs (i.e. $\ln X = x$):
$$q = s + p^* - p$$
Now the above should hold across multiple time periods so lets examine the changes between $t-1$ and $t$ where $\Delta x_t = x_{t}-x_{t-1}$:
$$\Delta q_t = \Delta s_t + \Delta p_t^* - \Delta p_t$$.
Now finally by definition inflation ($\pi_t$) is the change in price level so $\pi_t\approx \Delta p_t$ so lets substitute that in:
$$\Delta q_t = \Delta s_t + \pi_t^* - \pi_t$$.
Hence the change in real exchange rate reflects the change in nominal exchange rate adjusted for inflation in foreign country and home country.